Loop Job

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dspxlearn
Premium Member
Premium Member
Posts: 291
Joined: Sat Sep 10, 2005 1:26 am

Loop Job

Post by dspxlearn »

Hi,


I have a requirement in which i have a routine which reads the sequential file and this routine is to be called in "User variable activity stage". After this there is a "Job Activity" which takes the record from the "User variable activity stage" by the routine in it.

These two stages are enclosed in between "start Loop Activity" and "End Loop Activity".
For each time of execution of the loop the routine in the "User variable activity stage" should read the first record in the sequential file and to be passed to the "Job Activity".

This loop should execute till the maximum no. of count given in the "start Loop Activity" is reached.

The way it executes is.........

startLoopactivity---->User Variable Activity---->JobActivity----->EndLoopActivity

How should be the routine to be... :?: :roll:
Thanks and Regards!!
dspxlearn
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Lots of help already here for working with sequential files. Try reading your documentation or searching here for keywords like OPENSEQ, READSEQ, etc. Then ensure the routine returns whatever is appropriate from the sequential file to be used as a parameter value.

Move the User Variable Activity stage outside of the loop, sounds like you only need to call it once.
-craig

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