Hi ,
I am using stored procedure stage to invoke one stored procedure in db2.It does not have any i/o parameters. The procedure is creating one cursor .I need to get that cursor values as output values.
When i am trying to execute my job it is giving the following error.
Stored_Procedure_0,0: Error: [IBM][CLI Driver][DB2] SQL0805N Package "DD.TGTP1.DFDD.17D3BE2A09C24B29" was not found. SQLSTATE=51002
What could be the reason,
Thanks in advance
Mary
Stored Procedure
Moderators: chulett, rschirm, roy
This could be any number of issues. There is a limit on the name size for stored procedures in UDB, and if you have 2 or more procedures with the same name in the first(I think 15) characters, the system may not be able to find your procedure.
Make sure you have a procedure created with the same number of called variables that you are using, as it may not find the right version of the procedure(overloading is allowed).
Did you bind the package with the procedure?
Check your package path.
Ande
Make sure you have a procedure created with the same number of called variables that you are using, as it may not find the right version of the procedure(overloading is allowed).
Did you bind the package with the procedure?
Check your package path.
Ande