Re: routine in procname in *libl not unique

thank you. There were 2 specifics for the procedure.

select char(specific_schema,10) specific_schema,
char(specific_name,20) specific_name,
char(routine_schema,10) schema, routine_name
from sysroutines
where routine_schema = 'WLKLIB'

then I dropped one of them:

drop specific procedure dshsq00001



On Fri, Mar 22, 2013 at 10:05 AM, <rob@xxxxxxxxx> wrote:

What do you find when you query SYSROUTINES?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Steve Richter <stephenrichter@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 03/22/2013 09:57 AM
Subject: routine in procname in *libl not unique
Sent by: midrange-l-bounces@xxxxxxxxxxxx



I've been running RUNSQLSTM to successfully create an sql procedure. Now
the command fails with the message SQL0476 : Message . . . . : Routine
DSHSQ371 in *LIBL not unique.
Cause . . . . . : Function or procedure DSHSQ371 in *LIBL was specified,
not
by signature or specific name, and more than one specific instance of
the
routine was
found.

what does this error mean? I am able to drop the procedure and even
create
it again as a stub using STRSQL.

when I DSPOBJD OBJ(*ALLUSR/DSHSQ371) OBJTYPE(*ALL) the system shows only
1 object.

thanks,
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.