SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-47
COLUMNS Table
The columns TABLENAME through PICTURETEXT (1 through 17) were created in
version 1. The columns DATETIMESTARTFIELD through HEADINGTEXT (18 through
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
COBOL 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
24 CPRULESNAME CHAR(34) Name of collation associated with
column; "" if none
25 CPARRAYENTRY SMALLINT
SIGNED
Reserved for internal use by HP
26 CHARACTERSET CHAR(30) Name of the character set associated
with column
* Indicates primary key
Table C-3. The COLUMNS Table (page 2 of 2)
Column Name Data Type Description