home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
ewsqis5g.qry
< prev
next >
Wrap
Text File
|
1997-09-12
|
814b
|
34 lines
#NAME#
DA_LOGICALsegmentData
#DESCRIPTION#
This query collects information about segments in Logical DBDs.
DBD information is found through the Logical DBD sample query, ewsqid8g.qry.
Modifications:
Change the search criteria of the dbd name in the SQL WHERE clause.
To find all logical DBDs that use a specific physical segment (named <BE3ORDER>SE2ORDER<:>, for example) as source, replace the search criteria with
WHERE sourceSegmName = '<BE3ORDER>SE2ORDER<:>'
View type: DAQlogicalDBD
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT DISTINCT
d.segmentName,
d.parentSegmName,
d.dataAlso,
d.sourceSegmName,
d.sourceDBDname,
d.segmLabel,
d.segmDescription
FROM OUTER
DAQlogicalDBD d
WHERE
d.accessMethod = 'LOGICAL'
AND
d.dbdName LIKE '<>%'
ORDER BY 1 ASC