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]



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