| SQL Statement |
Purpose |
| CALL |
Calls a procedure. |
| CASE |
Selects an execution path based on multiple conditions. |
| Compound SQL |
Encloses SQL statements with BEGIN and END keywords. |
| Compound SQL (inlined) |
Combines one or more other SQL statements into an dynamic block. |
| Compound SQL (embedded) |
Combines one or more other SQL statements into an executable block. |
| Compound SQL (compiled) |
Groups other statements together in an SQL procedure. |
| FOR |
Executes a statement or group of statements for each row of a table. |
| GOTO |
Used to branch to a user-defined label within an SQL procedure. |
| IF |
Selects an execution path based on the evaluation of a condition. |
| ITERATE |
Causes the flow of control to return to the beginning of a labelled loop. |
| LEAVE |
Transfers program control out of a loop or a compound statement. |
| LOOP |
Repeats the execution of a statement or a group of statements. |
| PIPE |
Returns a row from a compiled table function. |
| REPEAT |
Executes a statement or group of statements until a search condition is true. |
| RESIGNAL |
Used to resignal an error or warning condition. |
| RETURN |
Used to return from a routine. |
| SIGNAL |
Used to signal an error or warning condition. |
| WHILE |
Repeats the execution of a statement or group of statements while a specified condition is true. |
