DSXchange

I have imported the Stored procedure metadata in DS Manager. (DS Manager - Import - Table Defintions - Store procedure Definition and then pop up import metadata (stored procedure ) gave procedure name and user id/pwd, dsn name). I have imported the same in the ODBC stage ( outputs - columns - load ...

Thanks. I had given the column names and datatypes (precision etc) in outputs - columns tab. I had called the SP using call statement in outputs - SQL Query - SQL Query primary inputs. But when I run the job, its aborting and giving the error - statement has incorrect number of result columns. What ...

Hi, I want to call a Store Procedure in a datastage ETL job. The store procedure is in SQL Server database. I want to pass some job parameters for some of the SP parameters and for the remaining SP parameter I want to use default values. I also have to perform some calculations on the result set of ...