ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-5
Language Elements
Language Elements
Language elements differ for Transact-SQL and NonStop SQL/MP. This subsection
describes how to use the following Transact-SQL language elements when using the
NonStop ODBC Server:
•
Names
•
Data types
•
Functions
•
Variables
•
Search conditions
•
Expressions and operators
•
Aggregates
•
Wild-card characters
•
NULL values
•
Comments
Names
When using the NonStop ODBC Server, the names you specify for objects such as
databases, tables, indexes, and columns must be in Transact-SQL syntax; however,
there are restrictions on some names, because the NonStop ODBC Server maps some
names to Guardian names.
This subsection summarizes name usage, then describes the following types of
names:
•
Database names
•
Owner names
•
Table, view, and index names
•
Column and correlation names
•
Procedure names
•
Transaction names
•
Variable names
Summary of Name Usage
In Transact-SQL, most names are Transact-SQL identifiers. NonStop SQL/MP does
not have corresponding identifiers. Therefore, the NonStop ODBC Server maps these
identifiers to NonStop SQL/MP simple names or Guardian names.