ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 309
SQL Statements A - D
BEGIN
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;