DSXchange

Hi ,

I would like to know how to declare the global variables and how we can use them in Datastage into expressions.

Actually I need to declare variables based on Oracle SQL Table data.
So wanted to know where we can write the query to declare the global variable?

Would appreciate the inputs !

Thanks !!

What version of DataStage? What operating system? Parallel or Server?

And what do you mean by "global"? That is, what scope do you see these variables having - for example within a sequence, within a project or across multiple projects?

Hi,

We have Datastage 8.1 Server Edition, And it is on Windows Server 2003.

By Global variables I mean to say,
It can be used across whole of the sequence Job.

Thanks & Regards,
Sanjeev

Declare them in a User Variables activity - they remain accessible to any activity downstream (that is, linked via any pathway to the User Variables activity).

Hi,

Thanks for the response.

I thought in the same way, But I am stuck in User variable activity that How a variable can be declared from database oracle table.

In brief, I wanted to declare the variable and assign the value to it by using some sql query on database table. But i am not able to find any function or utility where i can write SQL queries directly to access the database tables.

Thanks & Regards,
Sanjeev

Use a Job activity upstream of the User Variables activity. In that Job activity run a job to fetch the value from Oracle and park it somewhere, for example in the job's user status area or in a file. The User Variables activity can then assign a value to the variable by accessing that value.