home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
EWSQDEG.QRY
< prev
next >
Wrap
Text File
|
1997-09-11
|
911b
|
42 lines
#NAME#
DA_DataElementGlossary
#DESCRIPTION#
The Data Element glossary query returns the data specification and alias names of all Shareable Data Elements which match the specified name.
View type: DAQDataElement
Modifications:
Change the search criteria of the name of the shareable data element using the = (equals), IN or LIKE elements in the SQL WHERE clause.
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT DISTINCT
e.dataElement,
e.typeCode,
e.stringLength,
e.stringVaryingCode,
e.asBitData,
e.isLOB,
e.numericPrecision,
e.scale,
e.isSigned,
e.genericPicture,
e.isComplex,
e.vagSignFormat,
a.elementAlias,
p.lastUpdate,
p.addDate,
e.elementDescription
FROM OUTER
DAQDataElement e,
(e.elementAliases) a,
PartView p
WHERE
e.dataElement like '<>%' AND
e.dataElement=p.baseName
ORDER BY
e.dataElement,
a.elementAlias;