How to set Uservariable as a sequenece parameter in Sequence

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
kshanthi.dsx@gmail.com
Participant
Posts: 4
Joined: Tue Feb 07, 2012 12:42 am
Location: NA

How to set Uservariable as a sequenece parameter in Sequence

Post by kshanthi.dsx@gmail.com »

i have a routine, which picks up the Current date value in a file. I am using Uservariable activity and setting its value by running the routine.

When I use the user Variable in the activity stage of a job to set the parameters, It only picks up that value.

I have a sequence parameter called lastrundate which has no default value. I have job actyivity parameter, which is populated using the uservariable. I want the sequence to pick up the value from uservariable in job activity, only when when I don't supply the sequence parameter.
Now, when I supply the sequence parameter as some 'X' date, it is still using the job activity parameter, which is poulated using routine.

Now my question is how to use user variavble as sequenece parameter's default value ?
Please advise. Thanks a lot.
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

Create a routine or expression which evaluates the value of the sequence parameter. If unpopulated, return the value of the uservariable otherwise the value of the sequence parameter.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You can not change a sequence parameter value once the sequence has started. Use User variables or Activity variables to populate the job parameter values.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kshanthi.dsx@gmail.com
Participant
Posts: 4
Joined: Tue Feb 07, 2012 12:42 am
Location: NA

Post by kshanthi.dsx@gmail.com »

jwiles wrote:Create a routine or expression which evaluates the value of the sequence parameter. If unpopulated, return the value of the uservariable otherwise the value of the sequence parameter.

Regards,

Thanks. This worked for me. I really appreciate it.
shalu
Post Reply