RE: Dropping SQL stored procedure

["Jerry Myrick" <myrickjr@xxxxxxxxxxxxx>]

You will need to do a strsql from you AS/400 session. From there do a
drop procedure Library/SPNAME (parameter-type, ..., ...) Use Operations
Navigator to get the parameter-types for the SP you are trying to
delete. I don't have my SQL manual in front of me I might have the
syntax a little off. Goto IBM website and goto the Information Center
then to Databases if I'm wrong.

-----Original Message-----
From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]
On Behalf Of Jim Sneddon
Sent: Monday, August 19, 2002 1:09 PM
To: 'rpg400-l@midrange.com'
Subject: Dropping SQL stored procedure

This message is in MIME format. Since your mail reader does not
understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
I need to change a SQL stored procedure but when I go to DROP PROCEDURE
it
says:



 Message . . . . :   Function WB04025 in ALLSTSRC not unique.

 Cause . . . . . :   Function WB04025 in ALLSTSRC was specified, not by

   signature or specific name, and more than one specific instance of
the

   function was found.

 Recovery  . . . :   Request the function either by it's specific name,
or
by
   the function signature (function name with parameter types). Try the
request
   again.



If I look in the SYSPROCS file (select * from sysprocs) it shows these 2
entries:

SPECIFIC_NAME    ROUTINE_NAME

WB04025                 WB04025
WB04000002            WB04025

what is the syntax for differentiating between the two?

in the DB2 for OS/400 SQL reference it mentions a dot notation
(WB04025.WB04025) but sql says that ',' is an invalid token.  I tried
slashes also to no avail.

I'm assuming that the WB0400002 is the one created when I ran the
program
that creates it before I remembered to drop the first one but now I
can't
get either one of them to drop.

I even resorted to firing up Operations Navigator (<insert groan of
disgust
here>) and tried deleting them from there but I get the same message.

So I'm stuck.

Any help would be greatly appreciated.
Jim Sneddon
AS/400 Development Manager
Allstate Ticketing
1421 Sunset #4
Las Vegas, NV 89119
702-617-5540
www.showtickets.com

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.