(DB) DB2/Stored Proecedure

DB2.Store Procedure - Syntax

농부지기 2017. 1. 27. 23:24

[DB2.Store Procedure - Syntax ]

 

 

1. IF 문
     IF .. THEN
        ...
    ELSEIF  ... THEN
        ...
    ELSE
        ...
    END IF;
 

   IF   IS NULL THEN
         ....
   END IF;
 

2. WHILE 문
      WHILE 조건
           ....
       END;
 

3. goto 문
    Main_state:
           WHILE 조건
                  ....
                 LEAVE  Main_state:
           END;