Hi,
We have a mainframe file which has multiple record types(Header,Detail,Trailer) in it.
Each record type has its own format.
When I import the copybook structure of this file,the metadata is getting exported into 3 different record layouts.
Is there any way we can read the whole file using a single CFF stage and load different types of records into different datasets?
can we define 3 record structures in a single CFF stage?
Reading Multiple record types in a file using CFF stage
Moderators: chulett, rschirm, roy
Yes, you can declare multiple record types in a CFF stage. I am not at a DataStage client now, but you can declare various 01-level type records in the "Record" tab of the CFF stage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hi Andrw,ArndW wrote:Yes, you can declare multiple record types in a CFF stage. I am not at a DataStage client now, but you can declare various 01-level type records in the "Record" tab of the CFF stage.
Thanks for the information.I was unable to add multiple records in a single cff stage. Kindly let us know the procedure to do it.This step plays a key role in our project.Thanks in advance.
sun
I'm currently not at a DataStage client where I can post the exact steps, perhaps someone else might post the steps or you could look at the documentation for the CFF where the procedure is described. Just as in a COBOL program, you use one field to determine which record type is being used in that record and then use the appropriate record mask. All fields (for all record types) are declared but only those used for that record type are filled with data.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>