home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
ewsqid4g.qry
< prev
next >
Wrap
Text File
|
1997-09-12
|
927b
|
49 lines
#NAME#
DA_DEDBdbdData
#DESCRIPTION#
This query collects information about DEDB DBDs.
To get information about the segments in the DBD, use the DA_DEDBSegmentData query. To get information about fields in the DBD, use the DA_IMSfieldData query.
Modifications:
Change the search criteria of the dbd name in the SQL WHERE clause.
View type: DAQdedbDBD
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT DISTINCT
d.dbdName,
d.accessMethod,
d.rmName,
d.versionString,
d.captureRoutine,
d.exitData,
d.exitKey,
d.exitPath,
d.cascade,
d.cascadeData,
d.cascadeKey,
d.cascadePath,
d.ddName1,
d.dsDevice,
d.dsModel,
d.areaSize,
d.root,
d.rootOverflow,
d.uow,
d.uowOverflow,
d.pcbName,
d.psbName,
d.dbdLabel,
d.dbdDescription
FROM OUTER
DAQdedbDBD d
WHERE
d.accessMethod = 'DEDB'
AND
d.dbdName LIKE '<>%'
ORDER BY 1 ASC