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
mram33
Participant
Posts: 13 Joined: Fri Jun 09, 2006 1:29 am
Post
by mram33 » Wed Jul 12, 2006 7:47 am
I am getting following error while I am trying to use job parameter in the parallel job transformer stage.
Please let me know how to solve this issue?
Regards
Ram
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Wed Jul 12, 2006 7:53 am
What error message? How exactly are you using the job parameter ?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
mram33
Participant
Posts: 13 Joined: Fri Jun 09, 2006 1:29 am
Post
by mram33 » Wed Jul 12, 2006 8:01 am
DSguru2B wrote: What error message? How exactly are you using the job parameter ?
I am using $parameter_name in the expression editor of the transformer stage
Ram
thompsonp
Premium Member
Posts: 205 Joined: Tue Mar 01, 2005 8:41 am
Post
by thompsonp » Wed Jul 12, 2006 8:10 am
Try right clicking in the expression editor to build an expression with the correct syntax. One of the options on the right click menu is to add a job parameter.
thompsonp
Premium Member
Posts: 205 Joined: Tue Mar 01, 2005 8:41 am
Post
by thompsonp » Wed Jul 12, 2006 8:12 am
... read 'Derivation' instead of expression editior in my previous post
mram33
Participant
Posts: 13 Joined: Fri Jun 09, 2006 1:29 am
Post
by mram33 » Wed Jul 12, 2006 8:30 am
thompsonp wrote: ... read 'Derivation' instead of expression editior in my previous post
I am using the "job parameter" option from the list of options after the right click. And it is inserting $parameter_name.
Note: This parameter is added to the job from "user defined env variables"
Ram
thompsonp
Premium Member
Posts: 205 Joined: Tue Mar 01, 2005 8:41 am
Post
by thompsonp » Wed Jul 12, 2006 8:43 am
Whats the error message, and what's the derivation that uses the environment variable?
Looking in Director does the environment variable have a value?
panchusrao2656
Charter Member
Posts: 64 Joined: Sat Sep 17, 2005 10:42 am
Post
by panchusrao2656 » Wed Jul 12, 2006 2:11 pm
Instead of using the Job Parameter, try GetEnvironment($Parameter) and delete dollar sign. It worked for me.