ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-6
Names
Table 4-2 summarizes name format and how the NonStop ODBC Server handles
names.
Table 4-2. How the NonStop ODBC Server Handles Transact-SQL Object
Names (page 1 of 2)
Name Type Name Format
How NonStop ODBC Server Handles
Name
Database name NonStop ODBC-
database-name
Maps it to \node.$volume.subvolume, which
corresponds to a NonStop SQL/MP catalog.
Owner name logical-username Maps it to group-name.user-name, which
corresponds to a Guardian logon name.
Table name Transact-SQL identifier Maps it to an 8-character Guardian file
name.
Replaces $ and # and underscore (_) with
zero.
Replaces a leading underscore with the
letter u.
Might resort to generating a random name.
View name Transact-SQL identifier Maps it to an 8-character Guardian file
name.
Replaces $ and # and underscore with
zero.
Replaces a leading underscore with the
letter u.
Might resort to generating a random name.
Index name Transact-SQL identifier Maps it to an 8-character Guardian file
name.
Replaces $ and # and underscore with
zero.
Replaces a leading underscore with the
letter u.
Might resort to generating a random name.
Column heading Transact-SQL identifier Retains it, but does not map it. The client
can specify the column heading only in the
select list of a SELECT command. The
value is returned as the column heading in
the descriptor that precedes the result data.
Column name Transact-SQL identifier Maps it to a NonStop SQL/MP simple
name.
A column name cannot contain a dollar sign
($), number sign (#), or leading underscore
character (_). The server replaces $ and #
with an underscore and replaces a leading
underscore with the letter u.