How to Call DB2 Stored Procedure in 7.5.x2

dssiddu · Post by **dssiddu** » Wed Sep 29, 2010 2:46 pm

Hi DS Guys

I want to call the DB2 stored procedure in Ver 7.5x2 with input and output parameters.
The SP stage is there but its only for Oracle.So any other stages can use to call DB2 SP.

Adv thanks for your Information...

Thanks
SP

chulett · Post by **chulett** » Wed Sep 29, 2010 2:51 pm

I believe that your only other choice in that case would be the ODBC stage...

dssiddu · Post by **dssiddu** » Wed Sep 29, 2010 2:57 pm

Hi Thanks a lot for your quick resp..

But the current ODBC stage doesn't have the option to call Stored Procedure. Its having only Read Method: Auto generated SQL,TABLE,user defined sql.

Please your thouths..

Thanks
SP

ray.wurlod · Post by **ray.wurlod** » Wed Sep 29, 2010 5:26 pm

Surely user-defined SQL can issue a CALL (or EXEC) statement?

chulett · Post by **chulett** » Wed Sep 29, 2010 9:08 pm

Exactly.

dssiddu · Post by **dssiddu** » Thu Sep 30, 2010 8:22 am

HI Ray

Thanks a lot for your resp
But I used the call stmt also but it doesn't work for me getting the error msg saying that Invalid no of argumetns even i have given the exact number of parameters.

BTW how to give in and out parameter in ODBC stage. when we call SP using the stored procedure option in ODBC.Bcz have only parameters tab over there.

Can we give out parameter in the ODBC stage ???

ray.wurlod wrote:Surely user-defined SQL can issue a CALL (or EXEC) statement? ...