ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-38
Summary of Statements
Table 4-15 summarizes NonStop ODBC Server support of the control-of-flow
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.
Vector aggregates are not supported.
You cannot mix aggregate and nonaggregate
expressions in the select-list.
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 4-14. NonStop ODBC Server Support of Transact-SQL
Statements (page 3 of 3)
Transact-SQL
Statement
NonStop ODBC
Server Support Comments
x Indicates that the statement is supported
– Indicates that the statement is not supported