Read sequential variable length file

ray.wurlod · Post by **ray.wurlod** » Mon Jul 28, 2008 3:53 pm

Just as a test, can you read the file using the following record schema?
record
{final_delim=end, delim=none}
(
RecNum:string[18];
RecLength:string[max=3];
Other:string[max=50];
)

c62dr08 · Post by **c62dr08** » Tue Jul 29, 2008 6:46 am

Ray,
When I used your schema, I was able to browse only first and second columns.
FYI: Also, I want to use RCP on the transformer that goes right after Sequential file.
Thank you, Paul

ray.wurlod · Post by **ray.wurlod** » Tue Jul 29, 2008 4:46 pm

How strange. Can you please try using Char instead of VarChar for the length?
record
{final_delim=end, delim=none}
(
RecNum:string[18];
RecLength:string[3];
Other:string[max=50];
)

c62dr08 · Post by **c62dr08** » Wed Jul 30, 2008 8:58 am

Ray, it works now.
But how to include all the fields into file schema in order to use RCP?
Thank you, Paul

ray.wurlod · Post by **ray.wurlod** » Thu Jul 31, 2008 4:49 pm

I prefer not to use RCP, so someone else will need to answer that.

c62dr08 · Post by **c62dr08** » Fri Aug 01, 2008 9:16 am

The reason I want to use RCP is that I have to process nine different copybooks with hundreds of fields.
Any suggestions?