Calling Env Virables in Parameter Set

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
manojbh31
Premium Member
Premium Member
Posts: 83
Joined: Thu Jun 21, 2007 6:41 am

Calling Env Virables in Parameter Set

Post by manojbh31 »

Hi ,

I have a schema name defined as environment variable, Is it possible to call this variable or parameter in the parameter set.
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Edit the parameter set and click Add Environment Variable. The button is near the bottom of the parameters tab.
Choose a job you love, and you will never have to work a day in your life. - Confucius
manojbh31
Premium Member
Premium Member
Posts: 83
Joined: Thu Jun 21, 2007 6:41 am

Post by manojbh31 »

Sorry i wrote the question in wrong way, Can i call Env variable in value file name which is inside the parameter set.

Eg:-- I have value file name xyz
and parameters are source column, table names, where condition.

Can i call the env variable (which is Schema name) in parameter table names which is in parameter set xyz.
Mike
Premium Member
Premium Member
Posts: 1021
Joined: Sun Mar 03, 2002 6:01 pm
Location: Tampa, FL

Post by Mike »

I'm not sure if I understand...

but, no...

a parameter can not reference another parameter.

Mike
Post Reply