March 11, 2010, Thursday, 69


Condition Handling

From SQL PL Guide for DB2

Jump to: navigation, search

In most stored procedures it makes sense to specify an action when an error occurs. Because of this there're condition handlers available in DB2 SQL PL. There are three general handlers: SQLERROR, SQLWARNING and NOT FOUND. Furthermore handlers for specific conditions can be defined. This handlers must be created by the DECLARE statement.

...more details comming soon...