Re: routine in procname in *libl not unique

[Steve Richter <stephenrichter@xxxxxxxxx>]

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.