Hi,
I am executing stored prcoedure using ODBC, how to capture the result set (columns) in to variables,
so that when i run second prcoedure i want to pass this value to one of the input parameters of stored procedure.
Thanks
how to capture result set of SP in a variable.
Moderators: chulett, rschirm, roy
Hi,
One way would be to do a lookup using user defined sql and using the output columns from the result set your first ODBC SP got as key columns and taking thelookup columns returned from the second SP which is in the lookup as the derivation.
If this is not good for you please give more details regarding what you are trying to aceive.
IHTH,
One way would be to do a lookup using user defined sql and using the output columns from the result set your first ODBC SP got as key columns and taking thelookup columns returned from the second SP which is in the lookup as the derivation.
Code: Select all
ODBC --------> Xfm -------> TargetStage
^
|
|
ODBC
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org