View previous topic :: View next topic
|
Author |
Message |
HABBIE
New User
Joined: 08 Jul 2014 Posts: 24 Location: INDIA
|
|
|
|
Hi,
I am new to mainframe server.
I have connected to the mainframe server from the Db2 connect client. I can able to create some native stored procedures.while calling the procedure I m getting the below error.
db2 => CALL sum91();
SQL0444N Routine "SUM91" (specific name "") is implemented with code in library or path "", function "" which cannot be accessed. Reason code: "". SQLSTATE=42724
I don't understand what is this error for. Can some one kindly help me out.
My OS : Windows
Db2 version: 8.1 on mainframe
Thanks |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3051 Location: NYC,USA
|
|
|
|
Code: |
it means that, the external program called from the stored procedure is not found. Either the name is incorrect, or the program is not linked properly
"If the EXTERNAL_NAME column value is correct, use the MVS linkage editor to create the required MVS load module in one of the MVS load libraries used by your installation for stored procedures" |
|
|
Back to top |
|
|
|