ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-15
Statements
INSERT x You cannot insert rows into a view that
references more than one table, even if the
columns being inserted belong to only one
table.
INSERT must be inside a transaction if the
table is audited.
The select-list must follow these NonStop
SQL/MP rules:
•
The select-list must contain an
element for each column that you specify
in the column-name list.
•
A subquery cannot refer to a table, view, or
underlying table of the view into which
rows are being inserted.
KILL – –
LOAD DATABASE – –
LOAD
TRANSACTION
––
PRINT x Fully supported.
RAISERROR – –
READTEXT – –
RECONFIGURE – –
RETURN – –
REVOKE Accepted, but not
performed
–
ROLLBACK
TRANSACTION
x Transaction savepoints are ignored.
SAVE
TRANSACTION
x If used in the NonStop ODBC Server, the SAVE
TRANSACTION statement is ignored. No error
or warning messages are generated.
Table B-5. NonStop ODBC Server Support of Transact-SQL
Statements (page 5 of 7)
Transact-SQL
Statement
NonStop ODBC
Server Support Comments
x Indicates that the statement is supported
– Indicates that the statement is not supported