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
How to Call DB2 Stored Procedure in 7.5.x2
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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 ???
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? ...