Stored Procedure Stage help

vsanghvi · Post by **vsanghvi** » Wed Oct 12, 2005 12:46 pm

Hi

I am using stored procedure stage to read data from DB2 calling a specific stored procedure and writing to a seq file. SP takes 12 parameters and returns a cursor with 25 colums. In designer on my parameters tab of the sp stage I have listed first 12 parameters and then 25 output column names. Now on output tab under column tab I have same 12 + 25 list. They are mapped with the same column name.

Job compiles fine and runs file. However when i look at the output it has correct 12 + 25 colums and in first 12 it has the info for parameters and then it starts with the out put data but starts from 13th column data in 1st column. In other words it writes only 13 output colum data starting 13th one in 1-12 column and then everything is empty. I dont' know what it is doing with first 12 cursor output colums data. Anybody had similar issue ? Please share.

Thanks
VSanghvi

ray.wurlod · Post by **ray.wurlod** » Wed Oct 12, 2005 2:39 pm

Is this really a DataStage TX question?

vsanghvi · Post by **vsanghvi** » Mon Oct 17, 2005 8:03 am

Ray,

This is certainly not a TX question. I have added under Server Edition. I don't know why it got added here. Thanks for pointing it.

VSanghvi