Hi,

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,

db2 -[Email Address Removed] -f proc1

it returned an error saying that there is no such routines..


4. when i tried

db2 -[Email Address Removed] -f test.proc1

it executed successfully.

why the procedure 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.)

regards,
Sn

--
HE WHO DOES NOT UNDERSTAND YOUR SILENCE WILL NOT UNDERSTAND YOUR WORDS.

:-) Smile Always..,



DB2 & UDB email list listserv db2-l LazyDBA home page