DSXchange

Work around for this issue is: Build a command delimited for all the loop delimited variable AB_1 AB_2 AB_3 .... AB_N Becomes: AB_1,AB_2,AB_3.......AB_N Pass subset of list to each loop. So we If I have to process simultaneously using four loops to run one instance of one generic job, I have this do...

Thanks for your response:

I have DSODB set up and what I am looking for is not part of what is being captured. I have checked all the tables with the reference table. We currently use this repository to capture the status of our jobs

I want to ask where and how I can get the summary of sequence director log. Pipe it into a .txt readable file. I did not see this as part of Repository that we are using. I had read we can find it in the UV Database but want to be sure I can get it What I am looking for normally have the following e...

Thanks all for your response: What I want to do is make this jobs simple and scalable by simply adding List if the table grows in one simple location and the process will not be hindered. Secondly- How do I picking the last List and pass the next fifty list. I have a sample Powell Shell called in th...

Hello All- I want to ask this question concerning loops in DataStage with either list or numeric loop. I understand that loop work one at a time. My requirement is I have one single generic job that is used to load about 250 tables from source to target. Using list loop runs the cycle 250 time befor...

Hello All,

I want to ask for input how I can achieve this

rowgeneration--->sequentialfile

I want to use one job to generate multiple files. I believe I should be able to do this at run time. Any guidance will be appreciated.

Test1.txt
Test2.txt
....
...
Testn.txt