In this chapter, you will learn
Any textbook that deals with the subject of writing code is not complete without a discussion on how to process errors and other conditions. Anticipating and handling conditions is part and parcel of good, robust programming style. With DB2 SQL procedures, this is accomplished through the use of condition handlers. In fact, it is often desirable to also be able to check for and act on warnings that may be encountered. With DB2 SQL procedures, warnings are also a type of condition, and thus warnings and errors are handled in a very similar fashion. This chapter will describe the various types of condition handlers and techniques of how and when to use them.