fetching a column value in a variable

[tanaya.deshpande@tieto.co]

Hi ,

I want to fetch a column value in a select statement in sqlserver stage into a variable, this variable then would be passed to another job.

Can anyone help?

[priyadarshikunal]

There are various ways, just a few to list :-

Write a routine to call any ODBC tools command line function.

Write a routine using datastage ODBC Driver, as you are on windows you should not have problem with ODBC Licencing.

Write a job to extract the value in write to a flat file on datastage server, read it using cat command ( command will work because of MKS toolkit) in Execute command activity.


After doing any of the above pass the value as parameter to next job.