arif677@gmail.com wrote: |
We have been trying to call a stored procedure through COBOL-DB2 program and its failing at bind time with SQLCODE = -440, SQLSTATE = 42884. |
arif677@gmail.com wrote: |
SELECT * FROM REM_LOC.SCHEMA.TABLE_NAME I have tried using the PATH(REMOTE_SCHEMA) and it did not work. Any help is appreciated. |
Code: |
SELECT * FROM SYSIBM.SYSROUTINES WHERE NAME = 'your sp name' ; |
arif677@gmail.com wrote: |
Here is the error message:
SQLCODE = -440 SQLSTATE = 42884 SQLERRMT = REM_LOC.REM_SCHEMA.PROCEDURE_NAME PROCEDURE SQLWARN 0= ,1= ,2= ,3= ,4= ,5= ,6= ,7= ,8= ,9= ,A= STATEMENT= 151 |
Code: |
CONNECT TO REM_LOC CALL SCHEMA_NAME.STORED_PROCED (:HOST-VARIABLES.....) |
output generated using printer-friendly topic mod. All times are GMT - 5 Hours