home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
datatl25.zip
/
DCTDSGN.Z
/
EWSQDEDC.QRY
< prev
next >
Wrap
Text File
|
1997-09-11
|
2KB
|
80 lines
#NAME#
DA_DataElementDataCharacteristics
#DESCRIPTION#
The data element data characterstics glossary query returns the names of all shareable data elements which match the specified data specification.
View type: DAQDataElement
Modifications:
Change the search values (WHERE clause values) for:
--typeCode
Possible values are:
0 Binary number
1 Packed decimal
2 Zoned decimal
3 Binary floating point
4 Decimal (or external) floating point
5 Bit string
6 Character string
7 Double byte (or graphic) string
8 Mixed SBCS/DBCS string
9 Date
10 Time
11 Timestamp
12 Index
13 Undefined
14 RowID (Oracle only)
15 MLSLabel (Oracle only)
--stringLength
The data length for string data types: Bit string in bits, Character
string in bytes, DBCS or graphic string in double bytes, and mixed
SBCS/DBCS string in bytes.
--numericPrecision
The data length for numeric data types: Fixed binary in bits, Packed
decimal in digits, zoned decimal in digits, binary floating point in
bits, and decimal floating point in digits of the mantissa.
--scale
The position of the decimal point for numeric data types in digits.
--genericPicture
The language independent representation of a COBOL or PL/I picture clause.
--asBitData
A boolean value indicating whether the character string is treated
as bit (binary) data.
--isComplex
A boolean value indicating whether the numeric data is real (0) or
complex (1).
--isSigned
A boolean value indicating whether the numeric data is signed (0)
or not (1).
--stringVaryingCode
A value indicating whether the string is of fixed length (1) or
variable length (2).
--isLOB
A boolean value indicating whether the string is a large object (LOB)
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT
dataElement,
typeCode,
stringLength,
stringVaryingCode,
numericPrecision,
scale,
genericPicture,
asBitData,
isComplex,
isSigned,
isLOB
FROM
DAQDataElement
WHERE
-- as specified, this looks for a character string with length
-- less than 25 bytes
typeCode = 6 AND
stringLength < 25
ORDER BY
dataElement;