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 diagram
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-----'     
Notes:
  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.

Parent topic: Other syntax segments
Copyright© 2021 HCL Technologies Limited