OK,

If you truly already tried to drop this fully qualified proc and it
wouldnt drop, then what happened is that
you probably canceled a build. You need to open a pmr with IBM and get
them to give you a delpsm
binary for your OS to clean that out.






"DANIEL CALLAHAN
"
<db2udbdba-ezmlms To
hield-x99119202.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

10/31/2005 12:34 Subject
PM question about procedures














Hello All,

I'm submitting this on behalf of the signed name below as it seems to be
kicking
out of the forum.

------------------------------------------------------------------------

I'm new to DB2. I'm using DB2 UDB 8.2 on windows environment.

While I was trying to drop a procedure, I'm getting the following error
SQL0100W-No row was found for FETCH, UPDATE or DELETE; or the result of
query is an empty table. SQLSTATE=02000

I used the following syntax to drop the procedure. DROP PROCEDURE
drs_dps_dm_savpml;

There is only one signature available in sysibm.sysprocedures.I also tried
to drop the procedure using the following syntax.DROP SPECIFIC PROCEDURE
SQL051031100528726;

If I try to create the same procedure again, system doesn't allow me to
create. Please guide me on how to overcome this error and recreate the
procedure.

Thanks & Regards,
Bala Chandra

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




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