ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-36
Summary of Statements
Table 4-14 summarizes NonStop ODBC Server support of SQL statements.
Table 4-14. NonStop ODBC Server Support of Transact-SQL
Statements (page 1 of 3)
Transact-SQL
Statement
NonStop ODBC
Server Support Comments
ALTER TABLE x Supports the following syntax: ALTER TABLE ADD
(column-identifier data-type [,column-identifier
data-type])
BEGIN
TRANSACTION
x Nested transactions are not allowed.
Transaction names can be included but are not
meaningful.
DDL operations are allowed within a transaction.
COMMIT
TRANSACTION
x Transaction savepoints are ignored.
Transaction names can be included but are
ignored.
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
[UNIQUE] 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.
The fully expanded index name must be unique in
the network.
CREATE TABLE x Some data types are unsupported, and the
NonStop ODBC Server maps some data types to
NonStop SQL/MP data types.
The fully expanded table name must be unique in
the network.
The following clauses are not supported:
•
UNIQUE and PRIMARY KEY for column-
constraint-definition
•
Column-constraint-definition of
REFERENCES
•
Table-constraint-definition of UNIQUE,
CHECK, or FOREIGN KEY
x Indicates that the statement is supported
– Indicates that the statement is not supported