home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
ewsqid9g.qry
< prev
next >
Wrap
Text File
|
1997-09-12
|
1KB
|
59 lines
#NAME#
DA_INDEXdbdData
#DESCRIPTION#
This query collects information about Index DBDs.
To get information about the segments in the DBD, use the DA_SimpleSegmentData 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: DAQindexDBD
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT DISTINCT
d.dbdName,
d.sharedDBDname,
d1.dbdName,
d.accessMethod,
d.passwordFlag,
d.dosCompatibility,
d.protect,
d.versionString,
d.ddName1,
d.ddName2,
d.dsDevice,
d.dsModel,
d.inputRecordLength,
d.outputRecordLength,
d.size1,
d.size2,
d.overflowBlockingFactor,
d.primaryBlockingFactor,
d.hidamRootName,
d.hidamDBDname,
d.xdfldName,
d.targetSegmName,
d.targetDBDname,
d.ddataFieldName,
d.searchFieldName,
d.subseqFieldName,
d.sourceSegmName,
d.exitRoutine,
d.constant,
d.nullValue,
d.symbolic,
d.dbdLabel,
d.dbdDescription
FROM OUTER
DAQindexDBD d,
(d.sharingIndexDBD) d1
WHERE
d.accessMethod = 'INDEX'
AND
d.dbdName LIKE '<>%'
ORDER BY 1 ASC