I am trying to suppress warnings from SQL in CLP using its -w option
but had no luck to make it. So I have two dummy tables t and x of the
same simple structure, and table x is empty, then I am doing as follows
from CLP (DB2 LUW client):

db2 => select * from x

I
-----------

0 record(s) selected.


db2 => list command options
....
Option Description Current Setting
------ ---------------------------------------- ---------------
....
-w Display FETCH/SELECT warning messages ON
....


db2 => insert into t select * from x
SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result
of a
query is an empty table. SQLSTATE=02000


db2 => update command options using w off
DB20000I The UPDATE COMMAND OPTIONS command completed successfully.

db2 => list command options
....
Option Description Current Setting
------ ---------------------------------------- ---------------
....
-w Display FETCH/SELECT warning messages OFF
....

db2 => insert into t select * from x
SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result
of a
query is an empty table. SQLSTATE=02000


Why the FETCH warning still pops up? Any idea why?

Thanks,
-Eugene