Sybase 12.4.2 - Manual (Page 260)

Control statements
240
For complete descriptions of each, see the entries in “SQL Statements” in
Adaptive Server IQ Reference Manual.
Using compound statements
A compound statement starts with the keyword BEGIN and ends with the
keyword END . The body of a procedure is a compound statement. Compound
statements can also be used in batches. Compound statements can be nested,
and combined with other control statements to define execution flow in
procedures or in batches.
A compound statement allows a set of SQL statements to be grouped together
and treated as a unit. SQL statements within a compound statement should be
separated with semicolons.
Control statement Syntax
Compound statements BEGIN [ ATOMIC ]
statement-list
END
Conditional execution: IF IF condition THEN
statement-list
ELSEIF condition THEN
statement-list
ELSE
statement-list
END IF
Conditional execution: CASE CASE expression
WHEN value THEN
statement-list
WHEN value THEN
statement-list
ELSE
statement-list
END CASE
Repetition: WHILE, LOOP WHILE condition LOOP
statement-list
END LOOP
Repetition: FOR cursor loop FOR
statement-list
END FOR
Break: LEAVE LEAVE label
CALL CALL procname( arg, ... )