Posted: Tue Apr 12, 2005 6:47 pm Post subject: Record length for VB file when copied from VSAM file.
Hi,
I want to copy a KSDS file to a Variable length file. The maximum length of the VSAm file is 17679 and the average record length is 1087. I want to copy this VSAM file to the VB length file using IDCAMS REPRO. I am not sure what would be the record length to specify for VB file. If I assign 17679 as the record length, the space occupied will be huge. I am not sure if it is right to assign the average lecord length.
Please suggest.
Meg
Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Tue Apr 12, 2005 9:53 pm Post subject:
Meg,
Your output file LRECL should always be the maximum length of the vsam file. I would suggest that you use SORT with VLTRIM parameter.The VLTRIM parameter defines a byte to be deleted from the end of a variable-length record. All prior occurrences of this byte will also be deleted until a byte that is not equal to the trim byte is found. The resulting records are decreased in record length.
I assuming that you have spaces at the end of every record. so we remove all the trailing spaces using VLTRIM
Posted: Wed Apr 13, 2005 12:57 pm Post subject: Thanks. But the space occupied is huge. Any help?
Thanks Kolusu. That helped. But I just have a concern on the space. Earlier we had the compressed form of the VSAM file in the flat file using ADRDSSU utility and the space occupied was very less. But now since we are using Sort to simply copy the contents, the space occupied is very huge and we are unable to address this issue. Can I get any help around this.
Thanks,
Meg
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
