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

Statement Block

   .------------------------------.   
   V                              |   
|----+--------------------------+-+----------------------------->
     |                      (1) |     
     '-| DEFINE Statement |-----'     

   .------------------------------------.   
   V                                    |   
>----+--------------------------------+-+----------------------->
     |                            (2) |     
     '-| ON EXCEPTION Statement |-----'     

   .-----------------------------------------.   
   V                                         |   
>----+-------------------------------------+-+------------------|
     |                                (3)  |     
     +-| EXECUTE FUNCTION Statement |------+     
     |                                 (4) |     
     +-| EXECUTE PROCEDURE Statement |-----+     
     |                              (5)    |     
     +-| Subset of SPL Statements |--------+     
     |                              (6)    |     
     +-| Subset of SQL Statements |-----;--+     
     '-BEGIN--| Statement Block |--END-----'     

1. See DEFINE
2. See ON EXCEPTION and Identifier
3. See EXECUTE FUNCTION statement
4. See EXECUTE PROCEDURE statement
5. See Subset of SPL Statements Valid in the Statement Block
6. See SQL Statements Valid in SPL Statement Blocks

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. If a statement block is empty, no operation takes place when control of execution within the SPL routine passes to the empty SPL statement block.