SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-105
Conversion of DDL Elementary Items
Types
Conversion of FORTRAN Data Types
TYPE BINARY 32,scale NUMERIC (9,scale)
TYPE BINARY 32, scale
UNSIGNED
NUMERIC (9,scale) UNSIGNED
TYPE BINARY 64 LARGEINT
TYPE BINARY 64,scale NUMERIC (18,scale)
DDL NonStop SQL/MP
PIC nines PIC nines or if precision is greater than 9, PIC S nines
PIC S nines PIC S nines
PIC nines S PIC S nines
PIC T PIC S9
PIC T9(int) PIC S9(int+1)
PIC TV9(scale) PIC S9V9(scale)
PIC T9(int)
V9(scale)
PIC S9(int+1)V9(scale)
PIC 9(int)T PIC S9(int+1)
PIC V9(scale)T PIC SV9(scale+1)
PIC 9(int)
V9(scale)T
PIC S9(int)V9(scale+1)
nines is: { 9 (int [V9 (scale)] }
{ V9 (scale) }
Note. SQL supports only the unsigned and signed LEADING EMBEDDED DECIMAL data
types. The DDL SIGN LEADING SEPARATE or TRAILING SEPARATE DECIMAL data types
are converted to the SQL SIGN LEADING EMBEDDED DECIMAL data type.
DDL NonStop SQL/MP
TYPE COMPLEX PIC X(8)
TYPE FLOAT 32 REAL
TYPE FLOAT 64 DOUBLE PRECISION
DDL NonStop SQL/MP
nines is: { 9 (int [V9 (scale)] }
{ V9 (scale) }