home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
EWSQDMGG.QRY
< prev
next >
Wrap
Text File
|
1997-09-11
|
828b
|
34 lines
#NAME#
DA_DB2390StoragegroupGlossary
#DESCRIPTION#
The DB2/390 storage group glossary query returns the names of volumes and ICF catalogs used by the storagegroup.
View type: DAQDB2390Storagegroup
Modifications:
Change the search criteria of the storage group name using the = (equals), IN or LIKE elements in the SQL WHERE clause.
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT DISTINCT
s.db2390Storagegroup,
s.inRelationalSystem..relationalSystem,
s.inPhysicalDesign..db2390PhysicalDesign,
s.usesVolume..MVSVolume,
s.usesICFCatalog..ICFCatalog,
p.lastupdate,
p.addDate
FROM OUTER
DAQDB2390Storagegroup s,
PartView p
WHERE
s.db2390Storagegroup LIKE '<>%' AND
s.db2390Storagegroup=p.baseName AND
p.partType='DSRMRDStoragegroup'
ORDER BY
s.db2390Storagegroup;