SQL/MP Installation and Management Guide

Creating a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
5-31
Defining Columns
Q PIC 9(9) COMP PIC 9(9) COMP unsigned long o; int32; int(32) o
/INTEGER
UNSIGNED/;
R FLOAT(15) * Q: REAL IS
NOT
SUPPORTED
float q; real; real q;
S FLOAT(30) * R: DOUBLE
PRECISION IS
NOT
SUPPORTED
double r; longreal; real(64) r;
T REAL
(Same as
FLOAT(22) )
* S: REAL IS
NOT
SUPPORTED
float s; real; real s;
U DOUBLE
PRECISION
(Same as
FLOAT(54))
* T: DOUBLE
PRECISION IS
NOT
SUPPORTED
double t; longreal; real(64) t;
V DATETIME
YEAR TO DAY
PIC X(10). char u[11]; fstring(10); string u[0:9];
W DATE
(Same as
DATETIME
YEAR TO DAY)
PIC X(10). char v[11]; fstring(10); string v[0:9];
X TIME
(Same as
DATETIME
HOUR TO
SECOND)
PIC X(8). char w[9]; fstring(8); string w[0:7];
Y TIMESTAMP
(Same as
DATETIME
YEAR TO
FRACTION(3))
PIC X(26). char x[27]; fstring(26); string x[0:25];
Z INTERVAL
MONTH(6)
PIC X(7). char y[8]; fstring(7); string y[0:6];
Table 5-1. Summary of Corresponding Data Types (page3of3)
SQL/MP Column
Name and Data
Type COBOL C Pascal TAL