ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-12
Statements
BEGIN
TRANSACTION
x Nested transactions are not allowed.
Transaction names can be included but are not
meaningful.
DDL operations are allowed within a
transaction.
BREAK – –
CHECKPOINT – –
COMMIT
TRANSACTION
x Transaction savepoints are ignored.
Transaction names can be included but are
ignored.
CONTINUE – –
CREATE DATABASE x The ON DEFAULT clause is not supported.
You cannot specify the amount of space to
allocate for the database. NonStop SQL/MP
allocates disk space for tables and other
objects as you create them and enter data.
CREATE DEFAULT – Use the DEFAULT keyword on the NonStop
SQL/MP CREATE TABLE or ALTER TABLE
statement in pass-through mode.
CREATE INDEX x The following clauses are not supported:
•
CLUSTERED
•
WITH index-option
You cannot create a unique index on a column
that allows null values.
You can index BIT type columns; however, the
NonStop ODBC Server maps the BIT data type
to the NonStop SQL/MP SMALLINT data type.
You can index TEXT type columns; however,
the NonStop ODBC Server maps the TEXT
data type to the NonStop SQL/MP VARCHAR
data type.
The fully expanded index name must be unique
in the network.
CREATE
PROCEDURE
––
Table B-5. NonStop ODBC Server Support of Transact-SQL
Statements (page 2 of 7)
Transact-SQL
Statement
NonStop ODBC
Server Support Comments
x Indicates that the statement is supported
– Indicates that the statement is not supported