Parameter passing to sequential file stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
uegodawa
Participant
Posts: 71
Joined: Thu Apr 27, 2006 12:46 pm

Parameter passing to sequential file stage

Post by uegodawa »

Hi,
I want to pass source system as part of the file name. I've defined a job parameter called 'SOURCE_SYSTEM' and assigned value 'TEST'. Then I've entered the following value for File parameter in sequential file stage.

File=H:\Project\Work\#SOURCE_SYSTEM#_MASTER.txt

I can view data without any issues. But when I execute the job it's throwing the following error


Unable to open H:/Project/Work[&SOURCE_SYSTEM]_MASTER.txt: No such file or directory

Not sure why it didn't replace SOURCE_SYSTEM with parameter.

Any ideas???

Thanks
Thanks,
Upul
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It has substituted the parameter reference. Look at the "job starting" event in the job log to determine what value was actually passed to this parameter.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply