IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQL0444N on db2 mainframe


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
HABBIE

New User


Joined: 08 Jul 2014
Posts: 24
Location: INDIA

PostPosted: Tue Aug 11, 2015 7:31 pm
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2727
Location: NYC,USA

PostPosted: Wed Aug 12, 2015 1:45 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts access Mainframe from .net application All Other Mainframe Topics 0
No new posts How to determine TLS/SSL version in m... TSO/ISPF 2
No new posts Mainframe developer resources/communi... COBOL Programming 2
No new posts Prod parallel execution on mainframe ... CICS 1
No new posts Mainframe batch Job or REXX to get VT... CLIST & REXX 7
Search our Forums:

Back to Top