ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-32
CORE SQL Statements
CORE SQL statements are divided into the following categories:
•
Data Definition Language (DDL) statements
•
Data Manipulation Language (DML) statements
•
Transaction management statements
•
Stored procedure execution statement
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.
GRANT x Recognized, but not executed.
INSERT x Fully supported.
REVOKE x Recognized, but not executed.
SELECT x Fully supported.
UPDATE x Supported with one exception: you cannot
set a new value for a column that is part of
the primary key for the table.
Table 3-9. Supported CORE SQL Statements by Type (page1of2)
CORE SQL
Statement Description
Corresponding NonStop
SQL/MP Statement
DDL Statements
ALTER TABLE Adds new columns to an existing table. ALTER TABLE ADD
COLUMN
CREATE INDEX Creates indexes. CREATE INDEX
CREATE TABLE Creates new tables. CREATE TABLE
CREATE VIEW Creates views. CREATE VIEW
Table 3-8. NonStop ODBC Server Support of SQL Statements (page2of2)
CORE SQL Statement
NonStop ODBC
Server Support Comments
x Indicates that the statement is supported
– Indicates that the statement is not supported