ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-37
Summary of Statements
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.
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.
DROP DATABASE x Fully supported.
DROP INDEX x The following associated objects must be
accessible:
•
The underlying table
•
Catalogs containing the description of the
index
DROP TABLE x Dependent views are automatically dropped, but
you should drop them first because they are not
dropped from the mapping tables. Use REFRESH
afterward.
DROP VIEW x Dependent views are automatically dropped. Use
REFRESH afterward.
EXECUTE x Execution of stored procedures is supported, but
procedures must be created in the Pathway
environment.
INSERT x Fully supported.
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 4-14. NonStop ODBC Server Support of Transact-SQL
Statements (page 2 of 3)
Transact-SQL
Statement
NonStop ODBC
Server Support Comments
x Indicates that the statement is supported
– Indicates that the statement is not supported