home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
EWSQDU.QRY
< prev
next >
Wrap
Text File
|
1997-09-11
|
890b
|
38 lines
#NAME#
DA_DBDUsage
#DESCRIPTION#
The DBD usage impact query returns the names of all the DBDs and PCBs which use the definition of the DBD specified in the WHERE clause.
View type: DataAtlasDBD
Modifications:
Change the search criteria of the rootDBDname using the = (equals), IN or LIKE elements of the SQL WHERE clause.
#MODIFIED#
#VERSION#
#SQL STATEMENT#
--DA_DBDUsage
SELECT DISTINCT
d.rootDBDname,
d.dliAccess,
d.pcbName,
d.hidamDBDname as indexedDBD,
d.indexTargetDBDname as indexTargetDBD,
d.lchildDBDname as lchildDBD,
d.lparentDBDname as lparentDBD,
d.primaryIndexDBDname as primaryIndexDBD,
d.indicesDBDname as secondaryIndexDBD,
d.sourceDBDname as sourceDBD,
d.sourceDBDname1 as sourceDBD1
FROM OUTER
DataAtlasDBD d
WHERE
d.rootDBDname like '%'
ORDER BY
d.rootDBDname;