Creating Header / Detail file in CFF stage
Posted: Thu Nov 01, 2007 11:30 pm
Hi,
I need to create a fixed length file which has to be loaded into mainframe. It has got a header row followed by detail records.
The schemas of the header and detail records are different, and there are packed decimal fields at different locations in the header and detail records respectively.
Or if there is any better option of doing the same, please do suggest.
Thanks,
Vinod
I need to create a fixed length file which has to be loaded into mainframe. It has got a header row followed by detail records.
The schemas of the header and detail records are different, and there are packed decimal fields at different locations in the header and detail records respectively.
Can I create such a file using CFF stage? How do I specify different schemas for header and detail records in that case?$$HDR1 Field1 <packed decimal field>...
DetailRecord1 Field1 <packed decimal field>...
...
$$HDR2 Field2 <packed decimal field> ...
DetailRecord2 Field2 <packed decimal field>...
and so on
Or if there is any better option of doing the same, please do suggest.
Thanks,
Vinod