DSXchange

In 7.5.1 we have a 2 step process to read mainframe flat file with COMP fields.

(1) Job 1: Using FTP get complete column in 1 field and dump in text file.
Example: if file has 10 columns total 1000 char, read as varchar
(1000) in the transformer / source. The FTP transfer type is
"binary".

(2) Job 2: Using CFF and CFD decode the column and then dump in target.
In the CFF stage, instead of reading all 1000 char as 1 column,
load the Cobol File Definition in the "Columns" in CFF. This
translates all column appropriately.

In Version 8.0 using a PARALLEL job, is there a way to decode the mainframe file in ONE STEP only? Bascially using the FTP stage and the CFD stage, I would like to read all the ASCII and COMP values automatically.

You can use a single job if you have Federation Server.

Other option is FTP the Mainframe file through JCL to unix server and use Complex Flat File Stage to read this file.

I am currently using option 2 for my jobs as we don't have Federation Server.

Good Luck,

Aruna.

You can use a single job if you have Federation Server.

Other option is FTP the Mainframe file through JCL to unix server and use Complex Flat File Stage to read this file.

I am currently using option 2 for my jobs as we don't have Federation Server.

Good Luck,

Aruna.