IF#
Synopsis#
Description#
The IF THEN
statement is an optional construct to allow conditional processing
in SQL routines. Each condition
following an IF
or ELSEIF
must evaluate to a boolean. The result of processing the expression
must result in a boolean true
value to process the statements
in the THEN
block. A result of false
results in skipping the THEN
block and moving to
evaluate the next ELSEIF
and ELSE
blocks in order.
The ELSEIF
and ELSE
segments are optional.
Examples#
Further examples of varying complexity that cover usage of the IF
statement in
combination with other statements are available in the SQL routines examples
documentation.