Can we change length of CSV File

4235 pts.
Tags:
AS/400
AS/400 DB2
CHGPF
CSV
Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the legnth of CSV file?

Software/Hardware used:
AS/400

Answer Wiki

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

Actually I donot have a Source for this CSV file. its program described PF.

I have created the new file and copied the data.

Thanks,
Pradeep

Discuss This Question: 3  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
  • Koohiisan
    1) Copy current file to new temporary file 2) Change length of pf in source file 3) Delete logicals over pf 4) Recompile pf from source 5) Copy data from temporary file into newly compiled file using *MAP *DROP options 6) Recompile logicals you deleted earlier
    5,020 pointsBadges:
    report
  • TomLiotta
    If you are using a "program-described" PF to hold .CSV data, there is no way to increase the length. A new version must be created. Just rename the old one and create a new one with the original name and with the new length. Copy any data that you need to retain. There shouldn't be any logicals to be concerned about. Also, if this is really for .CSV data, it probably shouldn't be in a PF. It should be in a streamfile somewhere under the /root file system. There wouldn't be any issues with lengths in that case. Tom
    125,585 pointsBadges:
    report
  • deepu9321
    Actually I donot have a Source for this CSV file. its program described PF. I have created the new file and copied the data. Thanks, Pradeep
    4,235 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