SQL Control Statements

All SQL control statements are programmatic only. The following table provides a brief description of the SQL control statements.
idmscu
All SQL control statements are programmatic only. The following table provides a brief description of the SQL control statements.
Statement
Purpose
Invokes an SQL procedure.
Note:
The CALL statement is also a DML statement. The syntax and semantics of the CALL control statement are a subset of the CALL DML statement.
Determines the execution flow by the evaluation of one or more value-expressions.
Specifies a grouping of statements, with optional definitions of local variables, cursors, and handlers.
Starts a block of CA ADS code.
IF
Determines by evaluation of a search-condition, which block of statements are executed.
Begins a new iteration in a programmatic loop.
Exits a programmatic loop.
Defines a programmatic loop.
Defines a programmatic loop with an end condition.
Raises an SQL exception in a handler.
Exits an SQL routine or compound statement, optionally returning a value.
Assigns a value to a routine parameter, local variable, or host variable.
Note:
This statement can also be embedded in any SQL client program.
Raises an SQL exception.
Defines a programmatic, conditional loop.