Synametrics Technologies

I unchecked the Show Warning Messages option and restarted WinSQL. I am still getting the SQL0100W message from DB2 for DELETE statements that don't affect any rows. Shouldn't disabling Show Warning Messages hide that message?

Matt,

The "Show Warning Messages" option does not affect these type of messages. Some databases, such as MS SQL Server and Sybase use warning messages to display actual messages to the user. For example, in SQL Server you can writing something like:

PRINT 'Hello World'

In this case, it just prints Hello World to the user. The PRINT statement in SQL server uses the warnings mechanism in ODBC to deliver this message.

This checkbox has no affect when connecting to DB2 or Oracle, because these RDBMS do not use warnings.

Best regards,

Imran.

Thanks for your reply. You may wish to update your KB, as this is one of the recommended solutions when receiving this error: http://web.synametrics.com/norowsfound.htm