SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-18
COLS Table
17 DEFAULT_CLASS CHAR(2) Default defined by:
Blank No default
CD Current default
ND Null default
UD User default
IA Identity Always
ID Identity by 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
28 DATE_DISPLAY_FORMAT VARCHAR(64) Reserved for future use
29
CASE_SENSITIVE_COMPARI
SON
CHAR(2) Case-sensitive comparison, if
character type column.
Y case-sensitive
N case-insensitive
Column Name Data Type Description