By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,750 Members | 1,471 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,750 IT Pros & Developers. It's quick & easy.

How to call SQL Stored Procedure from REXX?

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.