Can we change length of CSV File
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
Software/Hardware used:
AS/400
ASKED:
May 10, 2011 11:22 AM
UPDATED:
May 11, 2011 5:48 AM
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
Other Answers:
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
To see other answers submitted to the Answer Wiki: View Answer History.
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
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