(Contents)(Previous)(Next)

Routines

A routine consists of a module header and a series of statements. Routines are indicated in the module header by the keyword PROC.

SQL-PL routines control the program flow, access to the data and the preparation of result data for output.

Routines communicate with other routines or forms of the same program either via common variables that are global within the program or via explicit module parameters.

Routines can also call functions and DB procedures. In this case, communication takes exclusively place via parameters.

Branching from one routine of a program to any routine of another program is possible, as long as the user has the execute privilege. The type of CALL statement determines whether or not this other program returns to the calling program after having been executed.


(Contents)(Previous)(Next)