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

All control statements are implemented according to SQL3.

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:

Block Statement
SET Statement
RETURN Statement
IF Statement
CASE Statement
LOOP Statement
WHILE Statement
REPEAT Statement
LEAVE Statement
FOR Statement
CALL Statement
SIGNAL Statement
RESIGNAL Statement

Object Declaration in SQL

SQL Language in 602SQL

Routines Stored on the Server