ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-5
Functions
For detailed information on expressions and operators, see Expressions and Operators
on page 4-29.
Functions
The NonStop ODBC Server does not support most SQL Server functions.
Table B-3 summarizes NonStop ODBC Server support of SQL Server functions.
!= x
!> x
!< x
*= x
=* x
Other ALL x
AND x
ANY x
BETWEEN x
EXISTS x
IN x
IS NULL x
LIKE x
NOT x
OR x
Table B-3. SQL Server Functions (page 1 of 4)
Function
NonStop ODBC
Server Support Comments
Date Functions
DATEADD x Fully supported. Dateparts used within the
function, however, have some restrictions.
DATEDIFF x Fully supported. Dateparts used within the
function, however, have some restrictions.
DATENAME – –
x Indicates a supported function
– Indicates an unsupported function
Table B-2. NonStop ODBC Server Support of SQL Server Operators (page 2 of 2)
SQL Server Operator Type Symbol NonStop ODBC Server Support
xIndicates a supported operator
–Indicates an unsupported operator