602SQL Documentation Index  

Control Statements (SQL)

The SQL language in 602SQL contains SQL2 and SQL3/PSM concepts. These constructs are local object declarations and control statements that allow you to combine the execution of traditional statements, routines and triggers.

Control statements allow you to assign values into variables, call routines, raise/process exceptions and create structured program constructs.

Variances from Intermediate to Full Level

The following statements may be used in the SQL language of 602SQL:

block statement REPEAT statement
assign statement SET LEAVE statement
RETURN statement FOR statement
IF statement CALL statement
CASE statement SIGNAL statement
LOOP statement RESIGNAL statement
WHILE statement  

List of topics: