Posted: Tue Feb 17, 2009 1:51 am
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.
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
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