ODBC Server Reference Manual

Summary of Support for SQL Server Features

HP NonStop ODBC Server Reference Manual—429151-002

B-9

Database Names

The format for a database name is:

node_volume_subvolume

You must separate the parts of the name with underscores (_).

Each portion of the name begins with a letter and consists of letters and numerals. 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

When specifying a database name in NonStop ODBC Server applications, do not

specify the backslash (\) and dollar sign ($) as part of the name.

Owner Names

Each SQL object belongs to an owner, identified by the logical username associated

with a Guardian logon ID by an ADDNAME USER statement.

The format for an owner name is:

logical-username

Case Sensitivity

Identifiers used with the NonStop ODBC Server are not case sensitive (My_Table is

the same as my_table). Identifiers used with SQL Server are case sensitive only if SQL

Server is configured to have case-sensitive identifiers.

For detailed information on identifiers, see Names

on page 4-5.

Joins

The NonStop ODBC Server supports all joins, including outer joins.

Portion Characters

node 7

volume 6

subvolume 8