Hi RTCCUT, Thanks a million. At least my stand was vindicated that Powercenter 7.1 cannot handle variable length VSAM file.

The following is the COBOL source code (CBLV80C1.cbl) used to read the input file containing fixed-length, 80-byte records and create an output file containing variable-length records. The output file will have variable length records consisting of the text string with the trailing spaces removed. IDENTIFICATION DIVISION. Var-a,var-b and var-d have fixed length in the file. I want to read the value of. Reply to: How to read variable length files. Compare VSAM files. We had the same problem last year and used Python to parse the different record types out to separate files so that each file was fixed length records. COBOL Examples Program Logic VSAM KSDS File Read. Reading a Variable Format File in. ALT INDX' 009300 WHEN '04' DISPLAY 'READ, WRONG LENGTH RECORD.

We had to purchase another software to split the file by record length. My Cricket Games. I did check with a few more friends and they had the same reply.=20 -----Original Message----- From: RTCCUT via informatica-l [mailto:informatica-l@Groups.ITtoolbox.com]=20 Sent: Monday, April 18, 2005 6:07 AM Subject: [informatica-l] Variable Length VSAM file We had the same problem last year and used Python to parse the different record types out to separate files so that each file was fixed length records with the same COBOL copy book definition.

It was a little difficult because like you, we had a 'record type indicator' in each record, but since the file was in EBCDIC, as we processed the file, we had to translate the EBCDIC record type indicator to ASCII and with that information we knew not only which file the record was written to, but also how many bytes to write to the output file. We were lucky to find an EBCDIC to ASCII Python routine on the internet to help with this task. Once you have the separate fixed length EBCDIC files, you can create an Informatica mapping for each using the COBOL copy book definitions. Hope this helps.

*Archives: *Manage Subscriptions: *Leave Group: mailto:leave-informatica-l@Groups.ITtoolbox.com *Need Subscription Help? Mailto:Listmaster@ITtoolbox.com *Terms of Use: *Copyright (c) ITtoolbox and message author.

No redistribution.