I am trying to find the quickest approach to change the length of one of our core application files. If I change the field using CHGPF manner, do I still have to recompile existing RPG programs and AS/400 queries?
Yes, if the CHGPF command (or ALTER TABLE statement) is used to change the length of an existing field, then you would need to recompile the RPG programs and AS/400 queries. The CHGPF command is the quickest way to alter the attributes of your database files, but you'll have to manually process any program recompiles that are needed.
Dig Deeper on iSeries database management
Create a host variable of the where in statement on the fly with dynamic SQL.
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ...
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ...