Execute Command Activity

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
PRIYARAJ
Participant
Posts: 41
Joined: Fri Jan 18, 2008 10:23 am

Execute Command Activity

Post by PRIYARAJ »

Hi All,

I am using an Execute Command activity in my job sequence and calling the parameter within the sequence.I wanted to convert the parameter into lower case.Is there any way that I can do in the sequence.

The reason for it is we have 5 different environments.Each time we migrate the code,we have to manually change the envrionments in all places.The parameter ENV holds the different values as per environment.In the same seq,it is used twice
1. To indiacate which environment whether is DEV or TEST(Uppercase)
2. To indicate the script path../dev/.....(lowercase)
So I there anyway that I can convert ENV to lower case in Sequnce.

Thanks in Advance!
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: Execute Command Activity

Post by gateleys »

You may use a User Variable stage and use the derivation downcase(your_param_name)
gateleys
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Or via a routine using the Routine Activity stage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
PRIYARAJ
Participant
Posts: 41
Joined: Fri Jan 18, 2008 10:23 am

Re: Execute Command Activity

Post by PRIYARAJ »

I have created User Variable Stage and the expression I had given there was downcase(ENV).
Is this correct?
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: Execute Command Activity

Post by gateleys »

PRIYARAJ wrote:I have created User Variable Stage and the expression I had given there was downcase(ENV).
Is this correct?
If that is your parameter, yes.
gateleys
Post Reply