ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-3
Names
Names
When using the NonStop ODBC Server, the names you specify for objects such as
databases, tables, indexes, and columns must be in CORE SQL syntax; however,
there are restrictions on some names, because the NonStop ODBC Server maps some
names to Guardian names.
This subsection summarizes name usage, then describes the following types of
names:
•
Database names
•
Owner names
•
Table, view, and index names
•
Procedure names
•
Column and correlation names
Summary of Name Usage
In CORE SQL, most names are CORE SQL identifiers. NonStop SQL/MP does not
have corresponding identifiers. Therefore, the NonStop ODBC Server maps these
identifiers to NonStop SQL/MP simple names or Guardian names.
A CORE SQL identifier is a user-defined name, not longer than 60 characters,
however, ODBC Server allows a maximum of only 30 characters. A CORE SQL
identifier begins with a letter; the remaining characters can be letters, digits, or
underscore (_) characters. The types of user-defined names are:
base-table-identifier
column-identifier
correlation-name
cursor-name
index-identifier
procedure-name-identifier
username
view-table-identifier
database-name
The database-name is not defined by CORE SQL, but is an extension of the
NonStop ODBC Server to support three-part names, available in ISO SQL. The
following constructs show valid examples of three-part names:
Base-table-
name
[ [database.]owner. ] base-table-identifier
[ database.. ]
View-table-name [ [database.]owner. ] view-table-identifier
[ database.. ]
Table-name [ [database.]owner. ] table-identifier
[ database.. ]