 Re: suppressing SQL0100W message
"Mehmet Baserdem" <mbaserdem@gmail.com> wrote in message
news:1148048927.096284.97030@y43g2000cwc.googlegro ups.com...[color=blue]
> 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
>[/color]
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
| 
