Page 1 of 1

DataStage variables

Posted: Sat Jul 30, 2011 10:24 am
by fmou
Hi,

Am I right that in the transformer stage, all kinds of variables can be used in output columns derivations, including transformer's own stage variables, job parameters, and user variables from the job sequence?

How about updating the variables? Only the transformer's own stage variables can be updated?

Thanks

Posted: Sat Jul 30, 2011 10:53 am
by chulett
"User variables" would need to be passed in as job parameters. You can't update job parameters, rather you use them in other derivations who's values can change.

Posted: Sat Jul 30, 2011 5:19 pm
by ray.wurlod
In short, you are not correct. Scope of User Variables is limited to the sequence itself; indeed only to activities directly downstream of the User Variables activity.

Viewing values of the User Variables and job parameters

Posted: Fri Aug 05, 2011 1:18 pm
by fmou
[reusing the old thread to ask a related question]

How can I view/debug the actual value of the User Variables and job parameters?

Thanks

Posted: Fri Aug 05, 2011 2:32 pm
by ray.wurlod
Job parameter values are reported into the job log. User variable values are not, but that doesn't matter if you've passed them as job parameters.