SQL0444N From Stored Procedure Builder

Srini S Rajan

SQL0444N From Stored Procedure Builder
dear members,

After a successful build of a sample stored procedures from DB2 Stored
Procedure to the
DB2 os/390 subsystem, I tried to execute the procedure and get the
following.
------------------------------------------------------------------
V649744.HELLO - Calling stored procedure.

[IBM][CLI Driver][DB2] SQL0444N Routine "SQL33705" (specific name "") is
implemented with code in library or path "", function "" which cannot be
accessed. Reason code: "". SQLSTATE=42724



V649744.HELLO - Changes rolled back.

V649744.HELLO - Done calling stored procedure.
---------------------------------------------------------------

can any one give a clue about solving this.

Srini S Rajan

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Vin db

Re: SQL0444N From Stored Procedure Builder
(in response to Srini S Rajan)
Srini,

Did you check out the reasons for the SQLSTATE 47274 ?
Two possible reasons are stated into following link:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnmch11/2.1.6.161?ACTION=MATCHES&REQUEST=42724&TYPE=FUZZY&SHELF=DSNSHHA1&DT=20010718150520&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

Hope this helps..

Cheers

Navin
Srini S Rajan <[login to unmask email]> wrote:
dear members,

After a successful build of a sample stored procedures from DB2 Stored
Procedure to the
DB2 os/390 subsystem, I tried to execute the procedure and get the
following.
------------------------------------------------------------------
V649744.HELLO - Calling stored procedure.

[IBM][CLI Driver][DB2] SQL0444N Routine "SQL33705" (specific name "") is
implemented with code in library or path "", function "" which cannot be
accessed. Reason code: "". SQLSTATE=42724



V649744.HELLO - Changes rolled back.

V649744.HELLO - Done calling stored procedure.
---------------------------------------------------------------

can any one give a clue about solving this.

Srini S Rajan

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm