suppressing SQL0100W message

[Mehmet Baserdem]

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

[Rhino]

"Mehmet Baserdem" <mb*******@gmail.com> wrote in message
news:11*********************@y43g2000cwc.googlegro ups.com...

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