ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-2
Using Transact-SQL Through the NonStop ODBC
Server
A Transact-SQL statement is submitted to NonStop SQL/MP as follows:
1. An application program issues a DB-LIBRARY call that sends a Transact-SQL
statement to the NonStop ODBC Server.
2. The NonStop ODBC Server translates the Transact-SQL statement to a NonStop
SQL/MP statement and sends the statement on 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
Transact-SQL format and sends the result to the application program.
5. The application retrieves the data using DB-LIBRARY calls.
Using Transact-SQL Through the NonStop
ODBC Server
This subsection summarizes some differences between using Transact-SQL in SQL
Server and using it in the NonStop ODBC Server. It covers the following topics:
•
Unsupported features
•
Mapping of table, view, and index names
•
DDL statements allowed in user-defined transactions
•
Specifying the database location
•
Batch queries
Figure 4-1. Relationships Among Transact-SQL, the NonStop ODBC Server, and
NonStop SQL/MP
Step 4:
Results in
DBLIB Format
Step 3:
NonStop
SQL/MP Results
Workstation
Step 2:
NonStop SQL/MP
Statements
HP Server
Step 1:
TRANSACT-SQL
Statements
NonStop
ODBC
Server
Application
With DBLIB
Calls
NonStop
SQL/MP
VST039.vsd