ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-6
Names
Database Names
A logical database name can be any valid NonStop SQL/MP identifier:
You must separate the parts of the name with underscores (_).
Considerations for database names are as follows:
•
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 name as
follows:
\node.$volume.subvolume
For example, if you specify the database name CORP_VOL2_SALES, the
NonStop ODBC Server maps it to the Guardian name\CORP.$VOL2.SALES, which
identifies the catalog SALES on the volume $VOL2 on the node \CORP.
For more information about Guardian names, see the Guardian User's Guide.
Owner Names
Each SQL object belongs to an owner. An owner name can be any valid
NonStop SQL/MP identifier and is identified by one of the following:
•
A logical username associated with a Guardian logon name by an ADD USER
statement.
•
A logical username associated with an alias username (and with a Guardian logon
name) by an ADD ALIAS statement.
Considerations for owner names are as follows:
•
An owner name is a CORE 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 reference that
object using the owner name (or the associated logical username for an alias
username) as a qualifier.
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.