COMP fields in Ver 8.0 using Parallel job

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
horserider
Participant
Posts: 71
Joined: Mon Jul 09, 2007 1:12 pm

COMP fields in Ver 8.0 using Parallel job

Post by horserider »

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.
Aruna Gutti
Premium Member
Premium Member
Posts: 145
Joined: Fri Sep 21, 2007 9:35 am
Location: Boston

Post by Aruna Gutti »

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.
Aruna Gutti
Premium Member
Premium Member
Posts: 145
Joined: Fri Sep 21, 2007 9:35 am
Location: Boston

Post by Aruna Gutti »

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.
Post Reply