DSXchange

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

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

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

Use GetEnvironment() to retrieve an environment variable value.

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.

nayanpatra wrote: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,

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

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