IDMS

IDD Reporting Using IDMS/SQL.zip 

06-10-2011 11:47 PM

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 

Statistics
0 Favorited
0 Views
1 Files
0 Shares
1 Downloads
Attachment(s)
zip file
IDD Reporting Using IDMS_SQL.zip   64 KB   1 version
Uploaded - 05-29-2019

Related Entries and Links

No Related Resource entered.