SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-16
COLS Table
14 UPSHIFTED CHAR(2) Y if type is CHAR, VARCHAR or PIC
with UPSHIFT clause
N if not
15 NULL_HEADER_SIZE INT Length of NULL indicator header
16 VARLEN_HEADER_SIZE INT Length of VARCHAR header
17 DEFAULT_CLASS CHAR(2) Default defined by:
Blank No default
CD Current default
ND Null default
UD User 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_PE
R_DAY
VARCHAR(128) Reserved for future use
Column Name Data Type Description