ODBC Server Reference Manual

Summary of Support for ODBC Features
HP NonStop ODBC Server Reference Manual—429151-002
A-7
Statements
Statements
The NonStop ODBC Server supports all of the ODBC CORE SQL statements,
although some have restrictions.
Table A-4 lists the CORE SQL statements and summarizes how each supported
statement differs when used with the NonStop ODBC Server.
Table A-4. NonStop ODBC Server Support of CORE SQL
Statements (page 1 of 2)
CORE SQL Statement
NonStop ODBC
Server Support Comments
ALTER TABLE x Fully supported.
CALL x Extension to CORE SQL—must appear in
an escape clause.
CREATE INDEX x The fully expanded index name must be
unique in the network.
CREATE TABLE x Of the column constraint definitions, only
NOT NULL is supported
Of the table constraint definitions, only
PRIMARY KEY is supported
The fully expanded table name must be
unique in the network.
CREATE VIEW x The fully expanded view name must be
unique in the network.
DELETE x The NonStop ODBC Server supports both
the positioned DELETE and the searched
DELETE.
DROP INDEX x Fully supported.
DROP TABLE x Fully supported.
DROP VIEW x Dependent views are automatically
dropped.
GRANT x* The NonStop ODBC Server recognizes the
syntax, but does not execute the
statement.
INSERT x Fully supported.
x Indicates that the statement is supported
* Indicates that the statement has limitations