Prev: Failover problems
Next: SQL0901N Error.
From: Eugene F on 16 Feb 2006 11:07 You can check to see if the DB2 driver that your application is using to communicate with DB2 database can be set to suppress warnings from DBMS. Also, if the driver supports that, instead of embedding SQL in your application, consider calling a stored procedure where you have much more flexibility to handle your logic and exceptions/warnings as well. -Eugene
From: Tonkuma on 16 Feb 2006 22:02 If you are using these statements in Stored Procedure, I think that you can use GET DIAGNOSTICS statement to get returned message text of a statement executed just before.
From: rAinDeEr on 17 Feb 2006 00:01
Hi all, Thanks for the output... I had a great learning and new options to use :-) ~ ME |