ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-17
Functions
Functions
Transact-SQL provides several types of functions for manipulating and retrieving data.
This subsection summarizes NonStop ODBC Server support of Transact-SQL
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 DISPLAY to
PIC S9(18) DISPLAY
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 X DISPLAY – CHAR if value is 0–255
VARCHAR if value is 256–4050
x VARCHAR
REAL – FLOAT
xFLOATN
SMALLINT signed – SMALLINT
xINTN
SMALLINT unsigned – INT
xINTN
TIME – DATETIME
xDATETIMN
TIMESTAMP Not supported
VARCHAR – VARCHAR
x VARCHAR
Table 4-6. Converting NonStop SQL/MP Data Types to Transact-SQL Data
Types (page 3 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