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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-14
COLS Table
5 COLUMN_NAME CHAR(128) Column name
6 COLUMN_SIZE LARGEINT Data bytes in column
7 SQL_DATA_TYPE CHAR(18) One of these SQL data types:
CHARACTER
DATE
DATETIME
SIGNED DECIMAL
UNSIGNED DECIMAL
DOUBLE
FLOAT
SIGNED INTEGER
INTERVAL
UNSIGNED BP INT
UNSIGNED INTEGER
SIGNED LARGEINT
SIGNED NUMERIC
UNSIGNED NUMERIC
REAL
SIGNED SMALLINT
UNSIGNED SMALLINT
TIME
TIMESTAMP
VARCHAR
LONG VARCHAR
8 CHARACTER_SET CHAR(40) Character set
9 ENCODING CHAR (40) Internal representation of columns
with character data types.
10 COLLATION_SEQUENCE CHAR(40) Collation
* Indicates primary key
Column Name Data Type Description