470,596 Members | 1,353 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

How to call SQL Stored Procedure from REXX?

I called Stored Procedure written in SQL from Object REXX on Windows
like this
CALL SQLEXEC 'CALL MigrateDECODE(:inString,:Converted)'
CALL CHECKERR 'CALL MigrateDECODE'
(CHECKERR was copied from DB2 sample program)
But, it returned -444 as followings. How can I call Stored Procedure
written in SQL from REXX?
--- error report ---
ERROR occurred : CALL MIGRATEDECODE
SQLCODE : -444
SQL0444N Routine "MigrateDECODE" (specific name "SQL061201015631890")
is
implemented with code in library or path "\MigrateDECODE", function
"MigrateDECODE" which cannot be accessed. Reason code: "4".
SQLSTATE=42724
--- end error report ---

Nov 30 '06 #1
2 3662
Tonkuma wrote:
I called Stored Procedure written in SQL from Object REXX on Windows
like this
CALL SQLEXEC 'CALL MigrateDECODE(:inString,:Converted)'
CALL CHECKERR 'CALL MigrateDECODE'
(CHECKERR was copied from DB2 sample program)
But, it returned -444 as followings. How can I call Stored Procedure
written in SQL from REXX?
--- error report ---
ERROR occurred : CALL MIGRATEDECODE
SQLCODE : -444
SQL0444N Routine "MigrateDECODE" (specific name "SQL061201015631890")
is
implemented with code in library or path "\MigrateDECODE", function
"MigrateDECODE" which cannot be accessed. Reason code: "4".
SQLSTATE=42724
--- end error report ---
I wish i could help you. We had an error like this (not in REXX) and i
don't remember what we did. My only guess would be to make sure that
the SCHEMA is set, so that any FUNCTIONs in the stored PROCEDURE
resolve properly, such as with the SET PATH command.

B.

Nov 30 '06 #2
Brian, Thank you for your prompt reply.
I resolved this isuue. I had connected to database without specifying
user id.
After I specified user id and password. It worked well.

Dec 1 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Jean-Marc Blaise | last post: by
7 posts views Thread by Jeff Wang | last post: by
2 posts views Thread by Massimiliano Campagnoli | last post: by
3 posts views Thread by mandible | last post: by
3 posts views Thread by cberthu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.