sorry for the typo error..

please ignore my previous post and find the exact scenario below,

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

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


4. when i tried

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




Sathya Narayanan wrote:

>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