DB2 Version 10.1 for Linux, UNIX, and Windows

Conditional statements in SQL procedures

Conditional statements are used to define what logic is to be executed based on the status of some condition being satisfied.

There are two types of conditional statements supported in SQL procedures:

These statements are similar; however the CASE statements extends the IF statement.