DSXchange

I need to loop 'x' times for a functionality. 'x' is a variable and can be passed as an environment variable to the job.

if x=4; I need to loop for a particular logic (coded within shared container) 4 times.

How can I handle looping in DataStage PX job?

Look into the Loop start and loop end activity stages in the sequence jobs.
If your control is at the unix level, you can code to run that particular job x number of times.

Thanks DSGuru!

The problem is the environment being used here doesnot support sequencer. I need to loop within DataStage job.

why dont u use "do while" in Unix scripting?

Krazykoolrohit wrote:why dont u use "do while" in Unix scripting?

The job flow design contains lot of other stuff within the job itself. The looping required is for different file merge with different schema and I am using Generic Stage to provide the dynamic expression files to merge operator.

This merge operator needs to be looped.

Thanks Everyone! I figured the answer out.

I need to create a buidop which will do the branching for me to divert to appropriate output link and select from appropriate input link.

skrakesh wrote:The problem is the environment being used here doesnot support sequencer. I need to loop within DataStage job.

All DataStage environments except mainframe support job sequences.