CFF multiple instance
Posted: Tue Dec 15, 2009 5:30 am
Hi all,
I want to design a job to read the EBCDIC file with records of multiple structures and save records with the same structure in one sequential file. I prepare to use CFF as input, and several sequential files as output. I have copybooks and table definitions in datastage for all the structures of records.
My question is that I have several EBCDIC files and every of them contains records of different structures, and I want to use one job allowing multiple instance to make it work for all EBCDIC files.
I wonder if there is a way to load the table definition via a schema file in CFF stage like what we can do in a sequential file stage. Then I can set the schema file name as a parameter and pass the value dynamically to the job in runtime. Like that I can make this job universal for all EBCDIC files no matter what's its structure. Can anybody give me an advice?
Thanks in advance!
I want to design a job to read the EBCDIC file with records of multiple structures and save records with the same structure in one sequential file. I prepare to use CFF as input, and several sequential files as output. I have copybooks and table definitions in datastage for all the structures of records.
My question is that I have several EBCDIC files and every of them contains records of different structures, and I want to use one job allowing multiple instance to make it work for all EBCDIC files.
I wonder if there is a way to load the table definition via a schema file in CFF stage like what we can do in a sequential file stage. Then I can set the schema file name as a parameter and pass the value dynamically to the job in runtime. Like that I can make this job universal for all EBCDIC files no matter what's its structure. Can anybody give me an advice?
Thanks in advance!