ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-31
CORE SQL Statements
END
FROM employee
For more information about the CASE expression, see the NonStop SQL/MP
Reference Manual.
CORE SQL Statements
The SQL statements you can use with the NonStop ODBC Server are a subset of the
ODBC CORE SQL statements. This section lists the supported CORE SQL statements
and summarizes how each statement differs when used with the NonStop ODBC
Server.
Ordinarily, if you use an unsupported statement with the NonStop ODBC Server, an
error message is generated. You can establish a user profile option, however, to ignore
errors from unsupported features. This option can be useful when you are running an
application that uses a feature whose action is not required, such as GRANT and
REVOKE.
Table 3-8. NonStop ODBC Server Support of SQL Statements (page1of2)
CORE SQL Statement
NonStop ODBC
Server Support Comments
ALTER TABLE x Reduced syntax.
CALL x Fully supported
CREATE
[UNIQUE] INDEX
x 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 The NonStop ODBC Server maps some
data types to NonStop SQL/MP data types.
See Data Types
on page 3-8.
The fully expanded table name must be
unique in the network.
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 Fully supported.
x Indicates that the statement is supported
– Indicates that the statement is not supported