ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-4
Expressions and Operators
For detailed information on data types, see Data Types on page 4-12.
Expressions and Operators
The NonStop ODBC Server supports SQL Server expression syntax except for some
operators. Table B-2 shows NonStop ODBC Server support of SQL Server operators.
SMALLINT x SMALLINT
SYSNAME x VARCHAR (30)
TEXT x VARCHAR
TINYINT x SMALLINT
USER_TYPE – –
VARBINARY – –
VARCHAR x VARCHAR
Table B-2. NonStop ODBC Server Support of SQL Server Operators (page 1 of 2)
SQL Server Operator Type Symbol NonStop ODBC Server Support
Arithmetic + x
-x
*x
/x
%x
Bitwise & –
|–
^–
~–
Comparison = x
>x
<x
>= x
<= x
xIndicates a supported operator
–Indicates an unsupported operator
Table B-1. Conversion of SQL Server Data Types to NonStop SQL/MP Data
Types (page 2 of 2)
SQL Server
Data Type
NonStop ODBC
Server Support Corresponding NonStop SQL/MP Data Type
x Indicates a supported data type
– Indicates an unsupported data type