calling environmental varible in transformer stage

[vinsashi]

Hi,
I declared one user defined environmetal varible "rec_flag" in administrator.I called that one job parameters in job.and in transformer stage for one column i called that job parameter(derivation is like this:$rec_flag).When compiling it showing error.

Thanks
V................

[nayanpatra]

The derivation should not start with $ for job parameters in a transformer stage

[vinsashi]

if we call that jobparameter we will get like that only........

[DSguru2B]

Use GetEnvironment() to retrieve an environment variable value.

[jwiles]

Use GetEnvironment() to retrieve an environment variable value.

And do this as the initial value derivation for a stage variable and then reference the stage variable in the output column. You DON'T want to call GetEnvironment() in an output column derivation...not a good practice.

[jwiles]

The derivation should not start with $ for job parameters in a transformer stage

As an FYI...this has changed with 8x. You can now directly use $-named job parms in a transformer.

Regards,

[ray.wurlod]

... only if they're in the job as parameters.

GetEnvironment() can reference any environment variable available to the process.