Code: Select all
SELECT MOD_DATE, COUNT(*) FROM UNNEST DS_AUDIT ON MODS GROUP BY MOD_DATE;
Code: Select all
INSERT INTO DICT DS_AUDIT(FIELD, CODE, LOC, NAME, FORMAT, SM, ASSOC) VALUES ('MOD_DATE', 'I', 'SUBSTRINGS(DTM,1,10)', 'Date Modified', '10R', 'M', 'MODS');
CD DS_AUDIT MOD_DATE