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…