Global variable with in a job

[rkdatastage]

Hi All
Can anyone share you idea that is there any chance to declare a global variable within a Parallel job , here i am not intersted to use environmental variable and parameter.

Thanks in advance
Regards
RK

[nagarjuna]

There are only three levels where you can declare a variable .

1) Job level

2) Project level

3) Env level

within a sequence you can try with uservariable activity .Is there any special reason for not using env variables ?

[rkdatastage]

Hi
Thanks for your response
there is a req for me like i need a value in some of the stages and that value i am getting it from a table. what is the best way to use that value which is coming from a table. I want to read it one time and want to use it in req stages and that is specific to a job level.
how can i define such a variable that can be used with in job level.

Regards
RK

[chulett]

That would be a job parameter. That means you need a 'pre-job' to do the selection and pass it to the job that needs to use it.

[rkdatastage]

Hi
Thanks for your response

Regards
RK

[chulett]

For the record, there is such a thing in a Server job: COMMON storage in a routine. As long as the stages you need to use it in are Transformer stages, it will support holding a value across multiple ones. With some caveats, of course.