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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-15
COLS Table
11 FS_DATA_TYPE INT File system data type. Values are:
0 fixed length ASCII string
64 variable length ASCII string
66 variable length double byte char
70 MXCS long varchar
130 16 bit signed
131 16 bit unsigned
132 32 bit signed
133 32 bit unsigned
134 64 bit signed
141 64 bit floating-point
142 32 bit floating-point
150 unsigned decimal
152 leading sign embedded
195 years
196 months
197 years and months
198 days
199 hours
200 days and hours
201 minutes
202 hours and minutes
203 days, hours, and minutes
204 seconds
205 minutes and seconds
206 hours, minutes, and seconds
207 days, hours, minutes, and
seconds
208 fractional seconds
12 COL_SCALE INT Scale if numeric; fractional seconds
if datetime or INTERVAL
13 COL_PRECISION INT If numeric, number of digits
If FLOAT, number of digits of binary
precision
If INTERVAL, first field
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
* Indicates primary key
Column Name Data Type Description