Kbase P154724: Error "SP_CMD in type *N not found" when used IBM Client Access driver to run stored procedure on as
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/9/2010 |
|
Status: Verified
SYMPTOM(s):
Error "SP_CMD in type *N not found" when used IBM Client Access driver to run stored procedure on as/400
S0002[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0204 - SP_CMD in type *N not found
User may also get the similar error as following:
S0002[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7976 - PREPARE os statement QZ9190AE56EEE70000 completed
FACT(s) (Environment):
Using Data Direct Wired Protocol driver the stored procedure runs fine
Following code example is being run
DEF VAR l-inllibl AS CHAR NO-UNDO INIT "ADDLIBLE MYLIB".
DEF VAR hdl AS INT NO-UNDO.
RUN STORED-PROC SP_CMD hdl = PROC-HANDLE (l-inllibl).
CLOSE STORED-PROC SP_CMD WHERE PROC-HANDLE = hdl.
Windows
OpenEdge 10.2B
OpenEdge 10.2A02
ODBC DataServer
CAUSE:
The library that contains the SP_CMD stored procedure is not on the user's library list so the stored procedure is not being found.
FIX:
Add the Library name that contains the SP_CMD on the IBM Client Access ODBC driver configuration > Server tab > Library list separated by a single space. For instance, If the SP_CMD is on library named called OELIB, the entry should look like the following:
*USRLIBL OELIB