Description

label
Specifies the label for the IF statement. The label name cannot be the same as the routine name or another label within the same scope. For more information, see Handling errors and warnings.
search-condition
Specifies the search-condition for which an SQL statement should be executed. If the condition is unknown or false, processing continues to the next search condition, until either a condition is true or processing reaches the ELSE clause.
SQL-procedure-statement
Specifies an SQL statement that should be executed if the preceding search-condition is true.