This entry consists of a number of SQL Views that greatly simplify reporting against IDD for those who are not familiar with Data Dictionary Reporter (Culprit DREPORTS), or the full flexibility of IDD DISPLAY ALL .... WHERE .... . etc syntax. The library includes two Cobol programs which implement SQL Gregorian to (SQL) Date conversion Functions. Using these Functions allows the SQL user to perform Date arithmetic in their SELECT statements - such as: select name, version, revisedby, reviseddate from RSQLSHR.RECORDCHANGED where ymd_sincemod < 90 and revisedby like 'J%' ; for example.
December 2nd, 2014: The link to the file was "broken" in the Jive conversion - I hope that this is now fixed - cheers - Gary