Stored procedure error handling
We can see error handling from two different, but complementary, points of view. From the server point of view, we are interested in how to report errors to the caller and how to manage errors that occur inside a procedure. From the client perspective, we are interested in how to retrieve error and warning conditions.
We review how to manage and report database error conditions. We also review how to manage database error and warning conditions on the client side.
Even if the tips and techniques that are shown in ...

Get External Procedures, Triggers, and User-Defined Functions on IBM DB2 for i now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.