Having a dynamic filename in the sequential file stage

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
aasaif
Participant
Posts: 98
Joined: Fri Sep 19, 2008 9:12 am

Having a dynamic filename in the sequential file stage

Post by aasaif »

I have source files that have ids prepended to each filename
In my sequentail file stage in the filename textbox is there anyway i can pass in a variablename in there. What i really want to do is pass in the filename as a job parameter and then read that parameter in the filename textbox
DS_SUPPORT
Premium Member
Premium Member
Posts: 232
Joined: Fri Aug 04, 2006 1:20 am
Location: Bangalore

Post by DS_SUPPORT »

Yes , you can do that. You can define a job parameter, like SEQFILENAME.
and in the filename textbox, just give like #SEQFILENAME#, it will be repalced by the value what you are passing in the job parameter.
Post Reply