SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-16
COLS Table
Column names that are regular identifiers are stored in uppercase letters. Column
names that are delimited identifiers are stored as is, without surrounding quotation
marks.
All other character columns except DEFAULT_VALUE and HEADING_TEXT store
letters in uppercase.
17 DEFAULT_CLASS CHAR(2) Default defined by:
Blank No default
CD Current default
ND Null default
UD User default
UF User defined function default
If CD, the value of the column
depends on its data type:
DATE Current date
TIME Current time
TIMESTAMP Current timestamp
18 LOGGABLE CHAR(2) Reserved for future use
19 DATETIME_START_
FIELD
INT First field if type datetime or
INTERVAL:
1 if year
2 if month
3 if day
4 if hour
5 if minute
6 if second
20 DATETIME_END_FIELD INT Last field if type DATE or INTERVAL;
6 if TIME or TIMESTAMP
21 DATETIME_LEADING_
PRECISION
INT Precision in digits of first field if
INTERVAL
22 DATETIME_TRAILING_
PRECISION
INT Number of digits in fraction (of a
second) if TIME, TIMESTAMP, or
INTERVAL when last field is second
23 DATETIME_QUALIFIER VARCHAR(28) If datetime, text for start and end
fields; blank for other types
24 DEFAULT_VALUE VARNCHAR (240)
CHARACTER SET
UCS2
Column default value. Stored as
Unicode characters.
25 HEADING_TEXT VARCHAR(128) Heading for column.
26 PICTURE_TEXT VARCHAR(64) PIC text if defined by COBOL85 PIC;
blank if datetime or real
27 COLUMN_VALUE_DRIFT_
PER_DAY
VARCHAR(128) Reserved for future use
* Indicates primary key
Column Name Data Type Description