Create variable blocked file in AS/400

[sudha]

Re: Create variable blocked file in AS/400

I just created PF with single field of length with varlen. then I have copied this file using cpytoimpf . But still it is coming as fixed blocked size file.
For example if first records ends in 10th position and second record ends in 15th position , then the cursor should move to 11th place for first record and 16th place for second record.
In my case cursor points to the record length of the file

[JonBoy]

Re: Create variable blocked file in AS/400

I did try to explain to you that this was not simple because there is no such thing as a variable length record in the iBM i database system.

Did you try telling it to trim trailing blanks?

If that doesn't work then I suggest you look at the CSV writer Open Access handler I wrote. You can find it here: Creating an OA CSV Writer http://www.ibmsystemsmag.com/ibmi/de...s-Open-Access/

You can trim the fields yourself. You could also use original files and let it split up the fields.

[as400Pro]

Re: Create variable blocked file in AS/400

I was listening to you Mr suit man in the big Hat.

[JonBoy]

Re: Create variable blocked file in AS/400

Glad someone was - sadly you're not the OP ;-)

[MichaelCatalani]

Re: Create variable blocked file in AS/400

Glad someone was - sadly you're not the OP ;-)

He's not, but he's dating a woman named Olga who he's never met, and is apparently a Tanya Tucker fan. So there's that.

I'm not sure how the OP is going to pull this off except by using a stream file and specifying the end of record delimiter (such new line or line feed, since I'm assuming that's how the "variable block" is working) I'm not exactly sure why that isnt the way to go, either. It's easy to do. A few minutes and its done.