NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-42
COLUMNS Table
13 SECONDLOWVALUE VARCHAR(20) First 20 bytes of second-lowest value in
column (ignoring nulls); stored as for
SECONDHIGHVALUE; set by
UPDATE STATISTICS
14 NULLALLOWED CHAR(1) Y if null values allowed
N if not
15 DEFAULTCLASS CHAR(1) S if column has system-defined default
U if user-defined default
N if no default
D if null default
16 DEFAULTVALUE VARCHAR(36) Default for column; stored in ASCII if
numeric; blank if system-defined
primary key; NULL if null; CURRENT
DATETIME if date-time type and
default SYSTEM
17 PICTURETEXT VARCHAR(64) Corresponding picture of column if
COBOL85 used to define column; blank
for date-time or real types
18
DATETIMESTARTFIELD
SMALLINT
SIGNED
Starting field of date-time or INTERVAL
data type:
1 if year
2 if month
3 if day
4 if hour
5 if minute
6 if second
7 if fraction
0 for other types
19 DATETIMEENDFIELD SMALLINT
SIGNED
Ending field of date-time or INTERVAL
type; same as DATETIMESTARTFIELD
20 DATETIMEQUALIFIER VARCHAR(28) Textual representation of
DATETIMESTARTFIELD and
DATETIMEENDFIELD; blank for other
types
21 UPSHIFT CHAR(1) Y if UPSHIFT specified
N if not
22 HEADING CHAR(1) Y if heading specified
N if not
23 HEADINGTEXT VARCHAR
(132)
Heading string if heading specified;
" " if not
Column Name Data Type Description
* Indicates primary key