BEGIN

The BEGIN statement is a compound statement and defines a group of statements within a procedure.

Scope

Procedures only

SQL Syntax

  BEGIN [Statement;][...] END;

Parameters

Statement: is the statement or statements between the begin and end of the statement.

Description

This statement can be used to improve readability.

Authorization

Anyone can use the BEGIN statement.

Example

   CREATE PROCEDURE PurchDB.DiscountPart(PartNumber CHAR(16)) 
   AS BEGIN
         DECLARE SalesPrice DECIMAL(6,2);
 
         SELECT SalesPrice INTO :SalesPrice 
           FROM PurchDB.Parts
          WHERE PartNumber = :PartNumber;
     
         IF ::sqlcode = 0 THEN
            IF :SalesPrice > 100. THEN
            BEGIN
               :SalesPrice = :SalesPrice*.80;
               INSERT INTO PurchDB.Discounts 
                  VALUES (:PartNumber, :SalesPrice);
            END
            ENDIF;
         ENDIF;
      END;

BEGIN

Technical documentation

» Table of Contents

» Index

Scope

SQL Syntax

Parameters

Description

Authorization

Example