LEAVE
statement allows processing of blocks in SQL
routines to move out of a specified context. Contexts
are defined by a label
. If no label is found, the functions
fails with an error message.
LOOP
labelled top
. The conditional IF
statement inside the loop can cause the exit from processing the loop when the
value for the parameter p
is 1 or less. This can be the case if the value is
passed in as 1 or less or after a number of iterations through the loop.
LEAVE
statement
in combination with other statements are available in the SQL routines examples
documentation.