DB2 Stored Procedure

DB2 create a stored PROCEDURE ---- add by liujx www.2cto.com -- initialize the 'account' field of the payment result query -- delete the Stored procedure drop procedure cmbbcd. UPDATE_CONDITION_VALUE (); -- DELETE data with key _ 0 from cmbbcd. CMCS3_CONDITION_LINE where key _ = '0'; -- create procedure cmbbcd. UPDATE_CONDITION_VALUE () language SQL FOR EACH_RECORD AS SELECT ID _ FROM CMBBCD. CMCS3_CONDITION do insert into cmbbcd. CMCS3_CONDITION_LINE VALUES (nextval FOR CMCS3_CONDITION_LINE_SEQ, id _, '0', current date, 4, 4, current date); end for; -- call cmbbcd when calling the stored procedure. UPDATE_CONDITION_VALUE (); ---- end