ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-2
Unsupported ODBC Features
A CORE SQL statement is submitted to NonStop SQL/MP as follows:
1. An application program issues an ODBC call that sends a CORE SQL statement to
the NonStop ODBC Server.
2. The NonStop ODBC Server translates the CORE SQL statement to a NonStop
SQL/MP statement and sends the statement to NonStop SQL/MP.
3. NonStop SQL/MP processes the statement and returns NonStop SQL/MP data (or
a diagnostic message) to the NonStop ODBC Server.
4. The NonStop ODBC Server translates the NonStop SQL/MP output to CORE SQL
format and sends the result to the application program.
The application then retrieves the data using ODBC calls.
Unsupported ODBC Features
In this manual, unsupported ODBC features are underlined. For example, in the
following syntax, the RESTRICT clause is unsupported. See the “Notation
Conventions” for other conventions used in syntax representations.
Language Elements
Language elements differ for CORE SQL and NonStop SQL/MP. This subsection
describes the following CORE SQL language elements when using the NonStop
ODBC Server:
•
Names
•
Data types
•
Escape clauses
•
Functions
•
Search conditions
•
Expressions and operators
•
Aggregates
•
Wild-card characters
•
NULL values
DROP TABLE base-table-name
[ CASCADE | RESTRICT ]