How to increase the legnth of CSV format file in AS400

[pradeep9321]

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?

[jamief]

Re: How to increase the legnth of CSV format file in AS400

delete it and just recreate it... I'm guessing its just a flat file?? one field and thats the name of the table also.

crtpf  mylib/myfile  rcdlen(2500) 

[pradeep9321]

Re: How to increase the legnth of CSV format file in AS400

Yes, its just a Flat file. I am also thinking to create a new file. But Still searching for the possibility of increasing the legnth of file.
Will it not possible to change the legnth of flat file. Anyway am going to create a new flat file.

[tomholden]

Re: How to increase the legnth of CSV format file in AS400

i would bother with a flat file. i'd just write it out as a stream file on the IFS directly