The GOTO statement permits a jump to a labeled statement
within a procedure.
Scope |
 |
Procedures only
SQL Syntax |
|
{[ GOTO GO TO ]} {[ Label Integer ]}
Parameters |
|
- Label
specifies an identifier label for branching within the procedure.
- Integer
specifies an integer label for branching within the procedure.
Description |
|
The label or integer referred to in a GOTO statement is followed by a
colon and a statement.
Authorization |
|
Anyone can use the GOTO statement.
Example |
|
CREATE PROCEDURE Process10 AS
BEGIN
INSERT INTO SmallOrders VALUES ('Widget', 10);
IF ::sqlcode <> 0 THEN
GOTO Errors;
ENDIF;
RETURN 0;
Errors: PRINT 'There were errors.';
RETURN 1;
END;
|
