Command for pulling data from two files!

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
kennyapril
Participant
Posts: 248
Joined: Fri Jul 30, 2010 9:04 am

Command for pulling data from two files!

Post by kennyapril »

Hello,

I am developing a sequence job and to pass the parameters to the parallel job which is being invoked from this sequence job. So in the process of getting the parameters I need to cat two files simultaneously for which I used cat file1;cat file2 using execute command.
Below is the format of the data in both the files.
File1:- sql1;sql2;sql3;.........;sql60
File2:- ,1start:1end;2start:2end;3start:3end;.......60start:60end

As using cat the data is together now divided by a comma.

Please provide me the commands to be used to pass sql1,1start,1end to the first run and then sql1,2start,2end to the second run and sql1,3start,3end............till sql60,60start,60end so total of in the loop of the sequence job.


Thank you!
Regards,
Kenny
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Guessing this may help.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply