home *** CD-ROM | disk | FTP | other *** search
/ OS/2 Shareware BBS: 10 Tools / 10-Tools.zip / datatl25.zip / DCTDSGN.Z / EWSQISG.QRY < prev    next >
Text File  |  1997-09-11  |  1KB  |  52 lines
  1. #NAME#
  2. DA_IncludedSourceGlossary
  3. #DESCRIPTION#
  4. The Included Source Definition glossary analysis query returns the names of the shareable data structures and shareable data elements used by the included source definition specified in the WHERE clauses.
  5.  
  6. View type:  DataAtlasIncludedSourceDef
  7.  
  8. Modifications:
  9. Change the search criteria of the included source definition name using the = (equals), IN or LIKE elements in both the SQL WHERE clauses.
  10.  
  11. #MODIFIED#
  12.  
  13. #VERSION#
  14.  
  15. #SQL STATEMENT#
  16. --DA_IncludedSourceGlossary
  17. SELECT DISTINCT
  18.   i.includedSourceDefiniton,
  19.   'Data Structure' as partType,
  20.   i.usesDataStructure as usesPart,
  21.   p.lastUpdate,
  22.   p.addDate
  23. FROM
  24.   DataAtlasIncludedSourceDef i,
  25.   PartView p,
  26.   PartView d
  27. WHERE
  28.   i.includedSourceDefiniton LIKE '<>%' AND
  29.   (i.includedSourceDefiniton=p.baseName AND
  30.   p.partType='DSIncludedSourceDef')    AND
  31.   (i.usesDataStructure=d.baseName AND
  32.   d.partType='DSDataStructure')
  33. UNION
  34. SELECT DISTINCT
  35.   i.includedSourceDefiniton,
  36.   'Data Element' as partType,
  37.   i.usesDataElement as usesPart,
  38.   p.lastUpdate,
  39.   p.addDate
  40. FROM
  41.   DataAtlasIncludedSourceDef i,
  42.   PartView p,
  43.   PartView d
  44. WHERE
  45.   i.includedSourceDefiniton LIKE '<>%' AND
  46.   (i.includedSourceDefiniton=p.baseName AND
  47.   p.partType='DSIncludedSourceDef')    AND
  48.   (i.usesDataElement=d.baseName AND
  49.   d.partType='DSDataElement')
  50. ORDER BY
  51.   1,2,3;
  52.