ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-13
Statements
CREATE RULE – Use the NonStop SQL/MP CREATE
CONSTRAINT statement in pass-through
mode.
CREATE TABLE x Some data types are unsupported, and the
NonStop ODBC Server maps some data types
to NonStop SQL/MP data types. See Data
Types earlier in this appendix.
The fully expanded table name must be unique
in the network.
CREATE TRIGGER – –
CREATE VIEW x You can modify data in a view only if the view is
derived from one table.
The fully expanded view name must be unique
in the network.
DBCC – –
DECLARE x Some data types are unsupported, and the
NonStop ODBC Server maps some data types
to NonStop SQL/MP data types. See Data
Types earlier in this appendix.
For information on usage differences, see
Variables
later in this appendix.
DELETE x The FROM clause is not supported. You
cannot specify more than one table name—you
cannot delete rows based on data stored in
other tables.
DELETE must be inside a transaction if the
table is audited.
DISK INIT – –
DISK REFIT – –
DISK REINIT – –
DROP DATABASE x Fully supported.
DROP DEFAULT – You cannot drop a default in NonStop SQL/MP.
Table B-5. NonStop ODBC Server Support of Transact-SQL
Statements (page 3 of 7)
Transact-SQL
Statement
NonStop ODBC
Server Support Comments
x Indicates that the statement is supported
– Indicates that the statement is not supported