Leaves a labeled procedural SQL statement.
The LEAVE-statement can be used to terminate the execution of a procedural-sql-statement.
The label is the beginning label of a procedural SQL statement within the scope containing the LEAVE-statement.
A procedural-sql-statement must have a beginning label if LEAVE is to be used to terminate its execution.
If the LEAVE-statement is contained in a compound statement the following actions occur before execution of the compound statement is terminated, after the LEAVE-statement is executed:
- Every open cursor declared in the compound statement is closed.
- All variables, cursors and handlers declared in the compound statement are destroyed.
- All condition names declared in the compound statement cease to be defined.
If the LEAVE-statement is executed within a compound statement forming the body of a procedure, execution of the procedure will be terminated.
SQL/PSM YES Fully compliant.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40