DSXchange

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 ...

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

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 ! Thank...