ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-11
Names
For more information, see the following documents:
Table, View, and Index Names
For table, view, and index names, you specify Transact-SQL identifiers. The NonStop
ODBC Server maps these identifiers to eight-character Guardian file names. Even
though the names are mapped, you refer to the object by its Transact-SQL name when
accessing it using the NonStop ODBC Server.
For more information, see the following documents:
Column and Correlation Names
For column names and correlation names, you specify Transact-SQL identifiers. The
NonStop ODBC Server maps the identifiers to NonStop SQL/MP simple names as
follows:
Even though the names are mapped, you refer to the column or correlation name by its
Transact-SQL name when accessing it using the NonStop ODBC Server.
Procedure Names
For procedure names, you specify Transact-SQL identifiers. The NonStop ODBC
Server maps these identifiers to the names of Pathway server class programs. Even
though the names are mapped, you refer to the object by its Transact-SQL name when
accessing it using the NonStop ODBC Server.
Transaction Names
For transaction names, you specify Transact-SQL identifiers. The NonStop ODBC
Server retains the transaction name, but does not map it because transaction names
are not used in NonStop SQL/MP.
For Information On See
Transact-SQL usernames Microsoft SQL Server System Administrator’s Guide
Name mapping Section 7, Managing Customized Catalogs
Guardian logon name Guardian User’s Guide
For Information On See
Transact-SQL object names Microsoft SQL Server Transact-SQL Reference
Mapping of table names Section 7, Managing Customized Catalogs
Mapping tables Section 8, HP NonStop ODBC Server Mapping Tables
Character Replaced With
Number sign (#) Underscore (_)
Dollar sign ($) Underscore (_)
Leading underscore (_) The letter U (uppercase)