Provides conditional branching.

Syntax

---

IF <BooleanExpression> THEN
   <StatementBlock>
[ELSEIF <BooleanExpression> THEN
   <StatementBlock>]
[ELSE
   <StatementBlock>]
END IF;

<StatementBlock> =

[[Label:]
BEGIN]
   [<Statement>;]
   [<Statement>;]
[EXCEPTION]
   [<Statement>;]
[END [Label];]

Usage

---

Use this statement to provide conditional branching based upon a single or multiple boolean expressions.

Examples

---

-- This procedure uses an IF statement
-- to conditionally test if the State column
-- is equal to 'FL', and if so, to change it
-- to 'NY'

PROCEDURE UpdateState()
BEGIN
   DECLARE CustCursor CURSOR WITH RETURN FOR Stmt;
   DECLARE State CHAR(2) DEFAULT '';

   PREPARE Stmt FROM 'SELECT * FROM Customer';

   OPEN CustCursor;

   FETCH FIRST FROM CustCursor ('State') INTO State;

   WHILE NOT EOF(CustCursor) DO
      IF (State='FL') THEN
         UPDATE CustCursor SET 'State'='NY';
      END IF;
      FETCH NEXT FROM CustCursor ('State') INTO State;
   END WHILE;
END

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: