Parameters

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
laknar
Participant
Posts: 162
Joined: Thu Apr 26, 2007 5:59 am
Location: Chennai

Parameters

Post by laknar »

how can i give parameters i.e Third Party tools

or is there any command for giving parameters from outside the job

if possible Please explain me how it works
sud
Premium Member
Premium Member
Posts: 366
Joined: Fri Dec 02, 2005 5:00 am
Location: Here I Am

Re: Parameters

Post by sud »

laknar wrote:how can i give parameters i.e Third Party tools

or is there any command for giving parameters from outside the job

if possible Please explain me how it works
You mean while running a job from command line? Please check out the dsjob command ... search the forum ... this has been covered many times.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
laknar
Participant
Posts: 162
Joined: Thu Apr 26, 2007 5:59 am
Location: Chennai

Post by laknar »

i tried to search but iam not able to find exact solution topic in forum.

please help me regarding this.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Search on keywords like 'dsjob -param'
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
sud
Premium Member
Premium Member
Posts: 366
Joined: Fri Dec 02, 2005 5:00 am
Location: Here I Am

Post by sud »

See, this is a sample command line invocation of a job through script :

Code: Select all

dsjob -run -wait -param RCPT_ID=${RCPT_ID} -param STATUS=${STATUS} -jobstatus myProjectName myJobName
which passes parameters RCPT_ID,STATUS to the job myJobName. Similarly you can pass in any number of parameters. In this example the value being passed is caught from the unix environment variables in place of which you could have read the parameter values from a parameter file and used those.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
Post Reply