Command for pulling data from two files!
Posted: Tue Jun 26, 2012 8:22 am
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!
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!