Hi all,

I am trying to call a stroed procedure

db2 " call p_prcname(?,?)"
SQL0440N No authorized routine named "P_PRCNAME" of type "PROCEDURE"
having compatible arguments was found. SQLSTATE=42884

But it works when I call like this
db2 " call boss.p_prcname(?,?)"

where boss is the schema name.

Can someone tell me how to over come this issue? I want to call the stored procedure without any prefix.
THANK YOU ALL IN ADVANCE

Connect as user BOSS or issue SET CURRENT SCHEMA BOSS before the SP call.

Adding to that: All database objects have a fully qualified name consisting of a schema name and an unqualified name. (This is standard SQL.) The schema name can be omitted, in which case the CURRENT SCHEMA special register is consulted (or the CURRENT FUNCTION PATH for routines) to resolve the object. The CURRENT SCHEMA special register is initialized by default with the current user-id.

set current schema boss didnt work it was giving me the same error.
the username and schema name are different is this going to be a problem.

Adding to the above if the user name and the schema are the same I am able to execute the procedure, but when they are different I am getting this error. Any suggestions please?

it worked when I set the current path to boss.
Thank you all.