db2 存储过程 if的例子及call调用方法

if 需要 end if;

 CREATE PROCEDURE UPDATE_SAL (IN empNum CHAR(6), 
                               OUT rating SMALLINT)
  LANGUAGE  SQL
  BEGIN
    IF rating = 1 THEN
      UPDATE employee 
      SET salary = salary * 1.10, bonus = 1000     
        WHERE empno = empNum;
    ELSEIF rating = 2 THEN
      UPDATE employee 
      SET salary = salary * 1.05, bonus = 500 
        WHERE empno = empNum;
    ELSE
      UPDATE employee 
      SET salary = salary * 1.03, bonus = 0 
        WHERE empno = empNum;
    END IF;
  END

调用： call UPDATE_SAL('emp001',?)

复杂的（主要关注BEGIN和END）

BEGIN
    BEGIN
        BEGIN
          IF NOT EXISTS(
                 SELECT 1 FROM STUDENT FETCH FIRST 1 ROWS ONLY
             ) THEN
             CALL TEST('');
          ELSE
            BEGIN
               IF EXISTS (
                SELECT 1 FROM STUDENT FETCH FIRST 1 ROWS ONLY
               ) THEN 
                   BEGIN
                      IF DEMO('AA')=1 THEN CALL TEST('');
                      END IF;
                   END;
               ELSE
                    BEGIN
                    END;
               END IF;
            END;
          END IF;
        END;
    END;
END

SQL 过程中的 IF 语句 - IBM 文档