Re: Adding columns to existing Infor files.

Apparently not all I/O is against logicals.  They follow the SQL rule to 
go against the base table
ACR125B

and that even does a SELECT *...  and a FETCH into :rcods

And I seem to remember some OS upgrade or PTF many years ago changing a 
soft warning about column truncation into a hard halt in just such an 
operation.


Rob Berendt
-- 
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to:  2505 Dekko Drive
          Garrett, IN 46738
Ship to:  Dock 108
          6928N 400E
          Kendallville, IN 46755
http://www.dekko.com





From:   [email protected]
To:     bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected]
Date:   10/02/2015 03:53 PM
Subject:        [BPCS-L] Adding columns to existing Infor files.
Sent by:        "BPCS-L" <bpcs-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]>



I know that in the past it was considered very bad form to even think 
about altering Infor's tables.
And people used to come up with all sorts of tricks like instead of adding 

columns to the IIM table you would create a new table, like IIM2 and put 
the same key on it and just add your new columns to that.  And then you 
would have to manually keep them in sync.  I am really hoping to avoid 
that for a number of reasons.

I don't think record format level checks by programs which read those 
tables with RPG and not SQL will be an issue because those reads are 
always against logical files which manually select the columns desired. 
Therefore, as far as the logical knows there will be no record format 
level change.

I even played around with ALTER TABLE against the RCO table and added a 
few columns and it seemed to have no negative ramifications.

I do realize I will have to document the heck out of this for doing Infor 
upgrades.  Or stick my ALTER TABLE statements in some source file or 
something.

I really do not want to try to keep in sync some matching table. 
Especially when the columns I want to add are automatically generated by 
the OS.  Like Current_User, Current_Timestamp and so forth.

What say ye?


Rob Berendt
-- 
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to:  2505 Dekko Drive
          Garrett, IN 46738
Ship to:  Dock 108
          6928N 400E
          Kendallville, IN 46755
http://www.dekko.com

-- 
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.



-- 
This is the BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.