ODBC Server Reference Manual

HP NonStop ODBC Server Reference Manual—429151-002
4-1
4 Transact-SQL Language
Applications used with the HP NonStop ODBC Server can contain Transact-SQL
statements. The NonStop ODBC Server accepts these Transact-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:
•
Summarizes the general differences between executing Transact-SQL statements
in SQL Server and executing them using the NonStop ODBC Server.
•
Describes the language elements, such as names, data types, functions, and
variables, used to construct Transact-SQL statements.
•
Summarizes the supported Transact-SQL statements.
•
Alphabetically lists and describes the Transact-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 Transact-SQL statement and the NonStop ODBC Server implementation
of the statement.
°
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 DB-LIBRARY calls
and Transact-SQL statements.
Figure 4-1
illustrates the relationships among Transact-SQL, the NonStop ODBC
Server, and NonStop SQL/MP.