IDD Reporting Using IDMS/SQL.zip

File uploaded by Gary_Cherlet on Jun 11, 2011Last modified by Gary_Cherlet on Dec 3, 2014
Version 3Show Document
  • View in full screen mode

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 

Outcomes