how to capture result set of SP in a variable.

harithay · Post by **harithay** » Wed Nov 16, 2005 10:18 am

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

roy · Post by **roy** » Thu Nov 17, 2005 1:38 am

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.

Code: Select all

ODBC --------> Xfm -------> TargetStage
                ^
                |
                |
              ODBC

If this is not good for you please give more details regarding what you are trying to aceive.

IHTH,