suppressing SQL0100W message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mehmet Baserdem - 19 May 2006 15:28 GMT

Is there any way to suppress SQL0100W message?

SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result
of a
query is an empty table. SQLSTATE=02000

Regards,

Mehmet Baserdem

Reply to this Message

Rhino - 20 May 2006 00:03 GMT

> Is there any way to suppress SQL0100W message?
>
> SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result
> of a
> query is an empty table. SQLSTATE=02000

Are you trying to suppress this message in a CLP (command line processor)
session? If so, I thought the CLP option to suppress warnings was 'w' so
that this _should_ work:

db2 -w- delete from employee where job = 'LUMBERJACK'

However, it doesn't work on my system, which is DB2 V8.2.1 on Windows XP.
Perhaps I've got a problem in my environment and it will work for you.
Otherwise, it's possible that SQL0100W is exempt from the 'w' CLP option.

If you try doing a Google Groups search on SQL0100W, you may find another
technique to suppress it.

--
Rhino

Reply to this Message