1  –  compound-use-statement

    See the Compound_Statement HELP topic for a description of the
    SQL statements that are valid in a compound statement.

2  –  END_IF

    Marks the end of an IF statement. Every IF statement must end
    with the END IF clause.

3  –  ELSE compound use statement

    Executes one or more SQL statements associated with the ELSE
    clause but only when the value of the IF and ELSEIF predicates
    evaluate to FALSE or UNKNOWN.

4  –  ELSEIF_THEN

    If the ELSEIF predicate evaluates to TRUE, SQL executes the SQL
    statements in the THEN clause. If the ELSEIF predicate does not
    evaluate to TRUE, SQL evaluates the predicates in any subsequent
    ELSEIF or ELSE clauses.

5  –  IF_THEN

    Executes one or more SQL statements in an IF . . . END IF block
    only when the value of an IF predicate evaluates to TRUE. A
    predicate, also called a conditional expression, specifies a
    condition that SQL evaluates to TRUE, FALSE, or UNKNOWN. If
    the predicate evaluates to TRUE, SQL executes the statement in
    the THEN clause. If the predicate does not evaluate to TRUE,
    SQL evaluates the predicate in any ELSEIF clauses. If the IF
    statement contains no ELSEIF clauses, SQL executes any statements
    in the ELSE clause.

6  –  predicate

    See the Predicates HELP topic for more information on predicates.