ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-7
Names
All names created using the NonStop ODBC Server are converted to uppercase letters
before any SQL statement processing occurs.
Table 4-3 summarizes the rules for creating Transact-SQL identifiers,
NonStop SQL/MP simple names, and Guardian names.
Correlation name Transact-SQL identifier Maps it to a NonStop SQL/MP simple
name.
Replaces $ and # with an underscore.
Replaces a leading underscore with the
letter u.
Procedure name Transact-SQL identifier Maps it to a Pathway server class, but the
user sees the name as identified to
Transact-SQL.
Transaction
name
Transact-SQL identifier Retains it, but does not map it. The server
ignores transaction names and does not
support Transact-SQL functions operating
on transaction-name.
Variable name Transact-SQL identifier
(no more than 29
characters) preceded by
an @ symbol.
Supported directly; not handled by the
ODBC server.
Table 4-2. How the NonStop ODBC Server Handles Transact-SQL Object
Names (page 2 of 2)
Name Type Name Format
How NonStop ODBC Server Handles
Name