home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
ewsqid2g.qry
< prev
next >
Wrap
Text File
|
1997-09-12
|
690b
|
34 lines
#NAME#
DA_MSDBdbdData
#DESCRIPTION#
This query collects information about MSDB 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: DAQmsdbDBD
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT DISTINCT
d.dbdName,
d.accessMethod,
d.msdbField,
d.msdbType,
d.versionString,
d.pcbName,
d.psbName,
d.dbdLabel,
d.dbdDescription
FROM OUTER
DAQmsdbDBD d
WHERE
d.accessMethod = 'MSDB'
AND
d.dbdName LIKE '<>%'
ORDER BY 1 ASC