Env Variables

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
DS_MJ
Participant
Posts: 157
Joined: Wed Feb 02, 2005 10:00 am

Env Variables

Post by DS_MJ »

Hello:

Would appreciate it if you could show me how to set a user defined environmental variable whos value is set to UPPER CASE can be set to lower case as and when required in other jobs sequences.

Thanks in advance.

Mamta
Thanks in advance,
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Something like this, perhaps?

viewtopic.php?t=119624
-craig

"You can never have too many knives" -- Logan Nine Fingers
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: Env Variables

Post by gateleys »

1. Set your user variables via the Admin client -> Properties -> Env Variables -> User variables. Let's suppose the variable is called MyVariable.
2. Initialize them in your sequence through job properties -> Parameter. You may assign $PROJDEF as its default value.
3. In the sequence, use a User variable stage. Define a variable called var. Set its properties to DownCase(MyVariable).

You are good to go.
gateleys
DS_MJ
Participant
Posts: 157
Joined: Wed Feb 02, 2005 10:00 am

Re: Env Variables

Post by DS_MJ »

gateleys wrote:1. Set your user variables via the Admin client -> Properties -> Env Variables -> User variables. Let's suppose the variable is called MyVariable.
2. Initialize them in your sequence through job properties -> Parameter. You may assign $PROJDEF as its default value.
3. In the sequence, use a User variable stage. Define a variable called var. Set its properties to DownCase(MyVariable).

You are good to go.
Thanks a bunch guys, appreciate it much.

Best Regards,
Mamta
Thanks in advance,
Post Reply