|
|
|
|
|
|
LEAVE
Leaves a labeled procedural SQL statement.
Usage
Description
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.
Restrictions
A procedural-sql-statement must have a beginning label if LEAVE is to be used to terminate its execution.
Notes
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.
Standard Compliance
Standard
Compliance
Comments
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|
