 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 7 matches |
| Author | Message |
|---|---|
 Topic: Stored procedure on Federated thru DB2 |
|
| arif677@gmail.com Replies: 10 Views: 8815 |
 Forum: Database Posted: Wed Jun 01, 2016 5:58 pm Subject: Stored procedure on Federated thru DB2 |
| Kolusu,
The issue has been resolved now.. We had to give the following: CONNECT TO REM_LOC CALL SCHEMA_NAME.STORED_PROCED (:HOST-VARIABLES.....) Also, when binding the program u ... |
|
| Topic: Stored procedure on Federated thru DB2 |
|
| arif677@gmail.com Replies: 10 Views: 8815 |
Forum: Database Posted: Wed Jun 01, 2016 2:57 pm Subject: Stored procedure on Federated thru DB2 |
| Hi Kolusu, The statement 151 points to stored procedure and the name is spelled correctly. Also I have tried removing the schema in the procedure and it give the same error. | |
| Topic: Stored procedure on Federated thru DB2 |
|
| arif677@gmail.com Replies: 10 Views: 8815 |
Forum: Database Posted: Wed Jun 01, 2016 1:45 pm Subject: Stored procedure on Federated thru DB2 |
| 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 |
|
| Topic: Stored procedure on Federated thru DB2 |
|
| arif677@gmail.com Replies: 10 Views: 8815 |
Forum: Database Posted: Wed Jun 01, 2016 1:22 pm Subject: Stored procedure on Federated thru DB2 |
| Kolusu, I have tried binding the program with PATH(REM_LOC.SCHMA_NAME) and it did not work. | |
| Topic: Stored procedure on Federated thru DB2 |
|
| arif677@gmail.com Replies: 10 Views: 8815 |
Forum: Database Posted: Wed Jun 01, 2016 1:16 pm Subject: Stored procedure on Federated thru DB2 |
| I have checked the schema from sysibm.sysroutines and it is correct. I think the PATH(SCHMA_NAME) but I have tried PATH(REM_LOC) and unfortunately it did not work. | |
| Topic: Stored procedure on Federated thru DB2 |
|
| arif677@gmail.com Replies: 10 Views: 8815 |
Forum: Database Posted: Wed Jun 01, 2016 1:00 pm Subject: Stored procedure on Federated thru DB2 |
| Thanks for the prompt reply... Let me provide some more details how we are compile and bind.
As we are accessing the tables and procedures on the remote server (Federated) which is not mainframes, ... |
|
| Topic: Stored procedure on Federated thru DB2 |
|
| arif677@gmail.com Replies: 10 Views: 8815 |
Forum: Database Posted: Wed Jun 01, 2016 10:58 am Subject: Stored procedure on Federated thru DB2 |
| We have been trying to call a stored procedure through COBOL-DB2 program and its failing at bind time with SQLCODE = -440, SQLSTATE = 42884.
The stored procedure we are calling from COBOL-DB2 progr ... |
|
All times are GMT - 5 Hours |