ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual429151-002
3-5
Names
For more information about identifiers, see the following documents:
Table 3-2. Rules for Object Names
CORE SQL
Identifier
NonStop
SQL/MP
Simple Name Guardian Name
Node
Name
Volume
Name
Subvolu
me Name
Object
Name
Length (in
characters
)
1–60* 1–30 1–8 1–7 1–8 1–8
First
character
Letter Letter Backslas
h (\)
$ Letter Letter
Remainin
g
characters
Letters
Digits
Underscore
(_)
Letters
Digits
Underscore
(_)
Letters
Digits
Letters
Digits
Letters
Digits
Letters
Digits
Example table_a second_val \finance
\system
$persnl
$disk01
pay1994 table1
* The NonStop ODBC Server allows a maximum of 30 characters for table names, view
names, and index names.
For Information About See
CORE SQL identifiers X/Open CAE Specification
NonStop SQL/MP identifiers NonStop SQL/MP Reference Manual