Grouping the records of DS_AUDIT

[ray.wurlod]

I couldn't get that to work either. But if you create the I-type in the file dictionary of DS_AUDIT and use that, it's all good.

Code: Select all

SELECT MOD_DATE, COUNT(*) FROM UNNEST DS_AUDIT ON MODS GROUP BY MOD_DATE;

To get the I-type into the file dictionary and functional you need two commands - one is SQL (with trailing semi-colon), the other is not.

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