drop procedure sp_DelTable_CommitCount@
CREATE PROCEDURE sp_DelTable_CommitCount(IN as_TableName VARCHAR(128) ,

                            IN as_Condition VARCHAR(1024) ,

                            IN abi_CommitCount BIGINT)

LANGUAGE SQL
BEGIN
       DECLARE  sm_End                 SMALLINT DEFAULT 0;
       DECLARE  retcode                INTEGER DEFAULT 0;
       DECLARE  SQLCODE                INTEGER DEFAULT 0;

       DECLARE  vc_DelStmt             VARCHAR(1024);
       DECLARE  vc_IntactStmt            VARCHAR(4096);
       DECLARE    vc_CreatViewStmt        VARCHAR(4096);
       DECLARE    vc_tmpviewname            VARCHAR(128);
       DECLARE    vc_DropViewStmt        VARCHAR(256);

       DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING
       BEGIN
           EXECUTE IMMEDIATE vc_DropViewStmt ;
           RESIGNAL;                  --

       END;

       DECLARE CONTINUE HANDLER FOR NOT FOUND
           SET  sm_End = 1;

    SET vc_IntactStmt = '( del_tmp_ID ) as  select  row_number()over()
from '||as_TableName||' where '||as_Condition;
    SET vc_tmpviewname = 'tmp_view'||Replace(Replace(Rtrim(char(current
timestamp)),'-',''),'.','');
    SET vc_DropViewStmt = 'DROP VIEW '||vc_tmpviewname;
    SET vc_CreatViewStmt = ' create view '||vc_tmpviewname||vc_IntactStmt
;

    EXECUTE IMMEDIATE vc_CreatViewStmt ;
       Commit_Loop:
       Loop

               SET vc_DelStmt = 'DELETE FROM '||vc_tmpviewname||'
where del_tmp_ID BETWEEN 1 AND '||RTRIM(CHAR(abi_CommitCount));
               INSERT INTO TMP4 VALUES (vc_DelStmt);
               EXECUTE IMMEDIATE vc_DelStmt;
               COMMIT;
               IF (sm_End=1) THEN
                   LEAVE Commit_Loop;
               End If ;

       End Loop Commit_Loop;

       EXECUTE IMMEDIATE vc_DropViewStmt ;

       return 0;                     
                       
END@