Control Statements

There are a number of control statements for logical flow and decision making in the body of the procedure or in a batch.

See SQL Anywhere Server - SQL Usage > Stored Procedures and Triggers > Using procedures, triggers, and batches > Control statements.

For complete descriptions of each, see the entries in Reference: Statements and Options >SQL Statements.

• Using Compound Statements
  Compound statements can be nested, and combined with other control statements to define execution flow in procedures or in batches.
• Declarations in Compound Statements
  Local declarations in a compound statement immediately follow the BEGIN keyword. These local declarations exist only within the compound statement.
• Atomic Compound Statements
  An atomic statement is a statement that is executed completely or not at all.