RD checks with no numbers
For M&K we did this:
FOR RD CHECK HEADER
CREATE OR REPLACE SEQUENCE CHK_NUM
START WITH 132228
INCREMENT BY 1
NO MAXVALUE
NO CYCLE;
UPDATE MKLLC.RDCHKHDR SET RD_CHD_NUM = NEXT VALUE FOR CHK_NUM
WHERE RD_CHD_DATE = '12/31/2024'
FOR GLCHECK (5 SECTIONS)
CREATE OR REPLACE SEQUENCE CHK_NUM
START WITH 132228
INCREMENT BY 1
NO MAXVALUE
NO CYCLE;
UPDATE MKLLC.GLCHECK SET MKLLC.GLCHECK.GL_CHK_NUM = NEXT VALUE FOR CHK_NUM
WHERE MKLLC.GLCHECK.GL_CHK_DATE = '12/31/2024' AND MKLLC.GLCHECK.GL_CHK_GLTYPE = 'RD' AND MKLLC.GLCHECK.GL_CHK_TYPE = 'C' AND MKLLC.GLCHECK.GL_CHK_ACCT = '100'
AND MKLLC.GLCHECK.GL_CHK_TRANS BETWEEN 134108 AND 134190
*****
CREATE OR REPLACE SEQUENCE CHK_NUM
START WITH 132293
INCREMENT BY 1
NO MAXVALUE
NO CYCLE;
UPDATE MKLLC.GLCHECK SET MKLLC.GLCHECK.GL_CHK_NUM = NEXT VALUE FOR CHK_NUM
WHERE MKLLC.GLCHECK.GL_CHK_DATE = '12/31/2024' AND MKLLC.GLCHECK.GL_CHK_GLTYPE = 'RD' AND MKLLC.GLCHECK.GL_CHK_TYPE = 'C' AND MKLLC.GLCHECK.GL_CHK_ACCT = '100'
AND MKLLC.GLCHECK.GL_CHK_TRANS BETWEEN 134195 AND 134274
****
CREATE OR REPLACE SEQUENCE CHK_NUM
START WITH 132360
INCREMENT BY 1
NO MAXVALUE
NO CYCLE;
UPDATE MKLLC.GLCHECK SET MKLLC.GLCHECK.GL_CHK_NUM = NEXT VALUE FOR CHK_NUM
WHERE MKLLC.GLCHECK.GL_CHK_DATE = '12/31/2024' AND MKLLC.GLCHECK.GL_CHK_GLTYPE = 'RD' AND MKLLC.GLCHECK.GL_CHK_TYPE = 'C' AND MKLLC.GLCHECK.GL_CHK_ACCT = '100'
AND MKLLC.GLCHECK.GL_CHK_TRANS BETWEEN 134279 AND 134806
****
CREATE OR REPLACE SEQUENCE CHK_NUM
START WITH 132752
INCREMENT BY 1
NO MAXVALUE
NO CYCLE;
UPDATE MKLLC.GLCHECK SET MKLLC.GLCHECK.GL_CHK_NUM = NEXT VALUE FOR CHK_NUM
WHERE MKLLC.GLCHECK.GL_CHK_DATE = '12/31/2024' AND MKLLC.GLCHECK.GL_CHK_GLTYPE = 'RD' AND MKLLC.GLCHECK.GL_CHK_TYPE = 'C' AND MKLLC.GLCHECK.GL_CHK_ACCT = '100'
AND MKLLC.GLCHECK.GL_CHK_TRANS BETWEEN 134808 AND 134930
****
CREATE OR REPLACE SEQUENCE CHK_NUM
START WITH 132841
INCREMENT BY 1
NO MAXVALUE
NO CYCLE;
UPDATE MKLLC.GLCHECK SET MKLLC.GLCHECK.GL_CHK_NUM = NEXT VALUE FOR CHK_NUM
WHERE MKLLC.GLCHECK.GL_CHK_DATE = '12/31/2024' AND MKLLC.GLCHECK.GL_CHK_GLTYPE = 'RD' AND MKLLC.GLCHECK.GL_CHK_TYPE = 'C' AND MKLLC.GLCHECK.GL_CHK_ACCT = '100'
AND MKLLC.GLCHECK.GL_CHK_TRANS BETWEEN 134932 AND 135269