7.4. PSQL Blocks

A self-contained, unnamed (anonymous) block of PSQL code can be executed dynamically in DSQL, using the EXECUTE BLOCK syntax. The header of a PSQL block may optionally contain input and output parameters. The body may contain local variables, cursor declarations and local routines, followed by a block of PSQL statements, and is similar to a stored procedure. A PSQL block cannot use a UDR module body.

A PSQL block is not defined and stored as an object, unlike stored procedures and triggers. It executes in run-time and cannot reference itself.

Like stored procedures, anonymous PSQL blocks can be used to process data and to retrieve data from the database.

Syntax (incomplete) 

  |EXECUTE BLOCK
  |  [(<inparam> = ? [, <inparam> = ? ...])]
  |  [RETURNS (<outparam> [, <outparam> ...])]
  |  <psql-module-body>
  | 
  |<psql-module-body> ::=
  |  !! See Syntax of Module Body !!

Table 7.3. PSQL Block Parameters
ArgumentDescription

inparam

Input parameter description

outparam

Output parameter description

declarations

A section for declaring local variables and named cursors

PSQL statements

PSQL and DML statements

See alsoSee EXECUTE BLOCK for details.