var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Procedure fails when i missed the schema name in its call
1. I ve set current schema to test
2. created a procedure PROC1 and compiled it successfully.
3. When i tried to execute the procedure in the command line processor,
it returned an error saying that there is no such routines..
4. when i tried
it executed successfully.
db2 -td@ -f test.proc1
My question is why the procedure proc1 failed when i called it without the schema name (even though the current schema is set to test in which the procedure is created and compiled.)
Like current schema is used for tables,views etc,
current function path is used for UDFs and SPs.
SET CURRENT FUNCTION PATH=ABCD,EFGH
will call procedure ABCD.TEST1().
If EFGH.TEST1() also exists, then the one with schema ABCD is called because it comes first in the FUNCTION PATH, more or less like OS's PATH variable
Originally Posted by Shefu
Visit the new-look IDUG Website
, register to gain access to the excellent content.