ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-8
Names
Identifiers used with the NonStop ODBC Server are not case sensitive (My_Table is
the same as my_table). Identifiers used with Transact-SQL are case sensitive only if
SQL Server is configured to have case-sensitive identifiers.
For more information on identifiers, see the following documents:
Database Names
A logical database name may be any valid NonStop SQL/MP identifier.
You must separate the parts of the name with underscores (_).
Considerations for database names are as follows:
Table 4-3. Rules for Object Names
Guardian Name
Transact-SQL Identifier NonStop SQL/MP Simple Name Node Name Volume Name Subvolume Name ObjectName
Length (in
characters)
1–30 1–30 1–8 1–7 1–8 1–8
First
character
Letter
Number sign (#)
Underscore (_)
Letter Backslash
(\)
$ Letter Letter
Remaining
characters
Letters
Digits
Number sign
Dollar sign ($)
Underscore
Letters
Digits
Underscore
Letters
Digits
Letters
Digits
Letters
Digits
Letters
Digits
Example table_a second_val \finance
\system
$persnl
$disk01
pay1994 table1
For Information On See
Transact-SQL identifiers Microsoft SQL Server Transact-SQL Reference
NonStop SQL/MP identifiers NonStop SQL/MP Reference Manual