home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
EWSQDSN.QRY
< prev
next >
Wrap
Text File
|
1997-09-11
|
789b
|
31 lines
#NAME#
DA_DBDSegmentName
#DESCRIPTION#
The DBD segment name glossary query returns the names of DBDs
which contain a segment which matches the segment name
specified in the WHERE clause.
View type: DataAtlasDBD
Modifications:
Change the search criteria of the structure alias attribute in the SQL WHERE
clause.
In order to provide unique segment names, the structureAlias has the format
<DBDName>SegmentName<variation:revision>. To find all DBDs which have
a specific segment name, use the LIKE clause with % between the first
two angle brackets.
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT DISTINCT
d.rootDBDname,
d.segmentName..structureAlias as segmentName
FROM
DataAtlasDBD d
WHERE
d.segmentName..structureAlias like '<%>%'
ORDER BY
1,2;