SQL Statements › CREATE PROCEDURE › CREATE PROCEDURE Syntax and Description › Example

Example

An IF-THEN statement example follows. In the example that follows, logic that is not shown (for space considerations) is indicated by three vertically arranged periods.

      .
      .
      .
      IF sqlStateLocal <-> '00000' THEN
         LEAVE loopExample;
      END IF;
      .
      .
      .