Home > IT Answers > AS/400 > Physical File record length
Rajasekhar15
1,350 pts.
 Physical File record length
AS/400 file specification, AS400 physical file, Physical Files
how to change PF record length?

Software/Hardware used:
ASKED: September 13, 2011  12:27 PM
UPDATED: March 31, 2012  4:41 PM
RELATED QUESTIONS
Answer Wiki:
If this is a flat file with just one field, I beleive you need to do a new CRTPF with the new RCDLEN If it has multiple fields, you need to change the DDS or SQL and create a new file. Either way you will need to fo a CPYF to get the data to the new file. If there are LFs, they will also need to be recreated. All programs referencing this file will need to be recompiled.
Last Wiki Answer Submitted:  September 13, 2011  3:26 pm  by  CharlieBrowne   32,785 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,785 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Usually, you don’t increase the length of a “record”. You increase the length of a field in the record, and the record length automatically gets adjusted.

As CharlieBrowne says, if this is a program-described file, you should simply recreate the file with a new record length.

But if it’s an externally-described file created with DDS, you might choose to change the DDS to update field lengths and then run CHGPF to get the file changed.

Or you might use the ALTER TABLE SQL statement to get similar results for a SQL table.

The exact procedure can be different depending on what change needs to be made. Tell us the details about the file for more information.

Tom

TomLiotta
 107,735 pts.