ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-16
Statements
SELECT x The following clauses are not supported:
•
INTO
•
GROUP BY ALL
•
COMPUTE BY
•
FOR BROWSE
You cannot include expressions in an
aggregate-free expression.
SELECT must be inside a transaction if it
queries audited objects.
Vector aggregates are not supported.
You cannot mix aggregate and nonaggregate
expressions in the select-list.
SET x Only two parameters are supported:
•
PARSEONLY
•
TEXTSIZE.
SETUSER – –
SHUTDOWN – –
TRUNCATE TABLE x TRUNCATE TABLE works at the same speed
as DELETE.
Changes are written to the audit log.
TRUNCATE TABLE must be inside a
transaction if the table is audited.
UPDATE x The FROM clause is not supported.
You can update data in a view only if the view
is derived from one table.
UPDATE must be inside a transaction if the
table is audited.
Aggregate functions are not allowed in the
expression.
UPDATE
STATISTICS
x You cannot specify the index for which to
update statistics.
USE x The new database takes effect as soon as the
statement is executed, not when the current
batch finishes.
Table B-5. NonStop ODBC Server Support of Transact-SQL
Statements (page 6 of 7)
Transact-SQL
Statement
NonStop ODBC
Server Support Comments
x Indicates that the statement is supported
– Indicates that the statement is not supported