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?
fetching a column value in a variable
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 94
- Joined: Sun Jul 18, 2010 11:35 pm
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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.
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.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.