ODBC Server Reference Manual

HP NonStop ODBC Server Reference Manual—429151-002
3-1
3 CORE SQL Language
Applications used with the HP NonStop ODBC Server can contain CORE SQL
statements. The NonStop ODBC Server accepts these CORE SQL statements,
translates them to HP NonStop SQL/MP statements, and sends the statements to
NonStop SQL/MP. The NonStop ODBC Server can also execute some NonStop
SQL/MP statements directly.
This section provides the following information:
•
Describes the language elements, such as names, data types, functions, and
variables, used to construct CORE SQL statements.
•
Summarizes the supported CORE SQL statements.
•
Alphabetically lists and describes the CORE SQL statements that you can use in
programs that interact with the NonStop ODBC Server.
•
Gives examples of each supported statement.
•
Explains the differences for each supported statement between the
NonStop SQL/MP statement and the NonStop ODBC Server implementation of the
statement.
NonStop ODBC Server Translation
Application programs used with the NonStop ODBC Server contain ODBC calls and
CORE SQL statements.
Figure 3-1 illustrates the relationships among ODBC, CORE SQL, the NonStop ODBC
Server, and NonStop SQL/MP.
Figure 3-1. Relationship Among CORE SQL, the NonStop ODBC Server, and
NonStop SQL/MP
HP Server
Step 4:
Results in
ODBC Format
Step 3:
NonStop
SQL/MP Results
Workstation
Step 2:
NonStop SQL/MP
Statements
Step 1:
CORE SQL
Statements
NonStop
ODBC
Server
Application
With ODBC
Calls
NonStop
SQL/MP
VST038.vsd