Hello friends,
We have a new project in which we need to develop the Datastage Jobs and prepare a schedule batch to run the jobs at schedule time.
We need to develop the jobs to read and process the sequential files which have a defined naming convention. We get 6 such files on a specific day.
My question is here to how to schedule my job to process all the files ( one by one) ?
Scheduling the jobs
Moderators: chulett, rschirm, roy
Scheduling the jobs
DS Developer
Welcome!
"One by one" would mean using a Sequence job with the "looping" stages - Start Loop and End Loop. You can use the User Variables Activity stage to generate / retrieve a delimited list of filenames and the Start Loop stage can iterate through them and pass them one at a time to your looped load job as a parameter.
What that would look like is spelled out pretty nicely in the pdf manuals you should have access to, that or online.
"One by one" would mean using a Sequence job with the "looping" stages - Start Loop and End Loop. You can use the User Variables Activity stage to generate / retrieve a delimited list of filenames and the Start Loop stage can iterate through them and pass them one at a time to your looped load job as a parameter.
What that would look like is spelled out pretty nicely in the pdf manuals you should have access to, that or online.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
This section of the documentation should help.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers