Using job parameter in the trasnformer 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
mram33
Participant
Posts: 13
Joined: Fri Jun 09, 2006 1:29 am

Using job parameter in the trasnformer stage

Post by mram33 »

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
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

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 »

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
Premium Member
Posts: 205
Joined: Tue Mar 01, 2005 8:41 am

Post by thompsonp »

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
Premium Member
Posts: 205
Joined: Tue Mar 01, 2005 8:41 am

Post by thompsonp »

... 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 »

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
Premium Member
Posts: 205
Joined: Tue Mar 01, 2005 8:41 am

Post by thompsonp »

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
Charter Member
Posts: 64
Joined: Sat Sep 17, 2005 10:42 am

Post by panchusrao2656 »

Instead of using the Job Parameter, try GetEnvironment($Parameter) and delete dollar sign. It worked for me.
Post Reply