Physical File record length

1,395 pts.
Tags:
AS/400 file specification
AS400 physical file
Physical Files
how to change PF record length?
ASKED: September 13, 2011  12:27 PM
UPDATED: March 31, 2012  4:41 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • Rajasekhar15
    [...] 9. One member is looking for help with changing a physical file record length. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following