Sybase 12.4.2 manual Using compound statements, Control statements, 240, Control statement Syntax

Control statements

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, ... )

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.

240