Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Other Syntax Segments >

Statement Block

Use a statement block to specify SPL and SQL operations to take place when an SPL statement that includes this segment is executed.

Syntax

Read syntax diagramSkip visual syntax diagramStatement Block:
 
   .-------------------------------.
   V                               |
|----+---------------------------+-+---------------------------->
     |                      (1)  |
     '-| DEFINE Statement |------'
 
   .-------------------------------------.
   V                                     |
>----+---------------------------------+-+---------------------->
     |                            (2)  |
     '-| ON EXCEPTION Statement |------'
 
   .------------------------------------------------.
   V                                                |
>----+--------------------------------------------+-+-----------|
     |  (3)                                  (4)  |
     +--------| EXECUTE FUNCTION Statement |------+
     |                                 (5)        |
     +-| EXECUTE PROCEDURE Statement |------------+
     |                              (6)           |
     +-| Subset of SPL Statements |---------------+
     |                              (7)           |
     +-| Subset of SQL Statements |------;--------+
     '-BEGIN--| Statement Block |--END------------'
 
Notes:
  1. See DEFINE
  2. See ON EXCEPTION
  3. Dynamic Server only
  4. See EXECUTE FUNCTION
  5. See EXECUTE PROCEDURE
  6. See Subset of SPL Statements Valid in the Statement Block
  7. See Subset of SQL Data Types

Usage

SPL and SQL statements can appear in a statement block, a set of zero or more statements that can define the scope of a variable or of the ON EXCEPTION statement of SPL. If the statement block is empty, no operation takes place when control of execution within the SPL routine passes to the empty SPL statement block.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]