ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-9
Names
•
Each portion of the name begins with a letter and consists of letters and digits. The
maximum number of characters for each portion is as follows:
•
The NonStop ODBC Server maps the database name to a Guardian identifier as
follows:
\node.$volume.subvolume
For example:
corp_vol2_sales maps to \corp1.$vol2.sales
For more information about Guardian names, see the Guardian User's Guide.
Owner Names
Each SQL object belongs to an owner, identified by the logical username associated
with a Guardian logon name by an ADD USER statement or the logical username
associated with an alias username (and with a Guardian logon name) by an ADD
ALIAS statement. Owner name is not specifically limited to group_user; it is stored as
an identifier in column NOS_USERNAME in the ZNSUS table.
An owner name may be any valid NonStop SQL/MP identifier.
Considerations for owner names are as follows:
•
An owner name is a Transact-SQL identifier.
•
An owner name is stored in the mapping tables with the associated object name.
When you create an object under a specific owner name, you must refer to that
object using the owner name (or the associated logical username for an alias
username) as a qualifier.
•
You specify an owner name as part of an index, table, view, or stored procedure
name as follows:
[ [database.]owner. ] object
[ database.. ]
If you include the database name but omit the owner name, you must include an
extra period to show the omission.
•
All object-name references are fully qualified before the SQL statement is
executed. If you do not specify an owner name, the logical username established
Portion Characters
Node 7
Volume 6
Subvolume 8
Note. Do not specify another owner when you create objects. If you do so, the other
owner is listed in the NonStop ODBC Server mapping tables, while you are the owner of
the object.