Statement 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------------'
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 ]