The DB2 Stored Procedure these are Steps to follow
The below are the steps in writing sample procedure in SQL. CREATE PROCEDURE update_sal (IN empnum CHAR(6), INOUT 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;