How to call SQL Stored Procedure from REXX?

[Tonkuma]

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 ---

[Brian Tkatch]

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.

[Tonkuma]

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.