ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-16
Data Types
xDATETIMN
DATETIME – DATETIME
xDATETIMN
DECIMAL (l,s)
l <= 4 and s=0 – SMALLINT
4 < l <= 9 and s=0 INT
l > 9 or s <> 0 FLOAT
l <= 4 and s=0 x INTN
4 < l <= 9 and s=0 INTN
l > 9 or s <> 0 FLOATN
DOUBLE PRECISION –
x
FLOAT
FLOATN
FLOAT – FLOAT
xFLOATN
INTEGER signed – INT
xINTN
INTEGER unsigned – FLOAT
xFLOATN
INTERVAL Not supported
LARGEINT – FLOAT
xFLOATN
NUMERIC (l,s)
l <= 4 and s=0 – SMALLINT
4 < l <= 9 and s=0 INT
l > 9 or s <> 0 FLOAT
l <= 4 and s=0 x INTN
4 < l <= 9 and s=0 INTN
l > 9 or s <> 0 FLOATN
PIC S9V9 COMP to
PIC S9(18) COMP
l <= 4 and s=0 – SMALLINT
4 < l <= 9 and s=0 INT
Table 4-6. Converting NonStop SQL/MP Data Types to Transact-SQL Data
Types (page 2 of 3)
NonStop SQL/MP
Data Type
Does the Object
Accept Null Values?
Corresponding Transact-SQL Data
Type
x Indicates the column accepts null values
– Indicates the column does not accept null values