CA 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

Tags and Keywords

Comments

12-02-2014 01:17 PM

I believe that the download link is now fixed

08-05-2013 11:24 PM

This seems to be missing :( I was able to download other files.

Thanks,
Cindy Kline

Related Entries and Links

No Related Resource entered.