MX 2.x)

Migrating Applications from NonStop ODBC Server

HP NonStop SQL/MX Connectivity Service Manual—524944-008

A-2

Server: Duplicating NonStop ODBC Server Logical

Database Object Names

3. Duplicate the NonStop ODBC Server logical database object names to the

SQL/MX environment. For detailed information, see Server: Duplicating NonStop

ODBC Server Logical Database Object Names on page A-2

4. Migrate the NonStop ODBC Server configuration settings to MXCS. For detailed

information, see Server: Migrating NonStop ODBC Server Configuration Settings

on page A-5.

5. Preserve the user alias settings. For detailed information, see Server: Preserving

User Alias Settings on page A-9

Server: Duplicating NonStop ODBC Server

Logical Database Object Names

Database Object Names

Both products use three-part logical names to identify database objects, as follows:

NonStop ODBC Server database.owner-name.object-name

SQL/MX catalog.schema.object-name

The following table lists the relationships between the database object names:

In the NonStop ODBC Server, a database name is in the form:

system-name_volume-name_subvolume-name

The system_name is the name of the NonStop system without the backslash (\). The

volume_name is the name of the volume without the dollar sign ($), and

subvol_name is the name of the subvolume. Do not use periods between the names

because the name represents one logical name for each catalog and schema.

ODBC metadata information (through ODBC Catalog APIs) is returned based on the

values for each of the three parts, which describe all database objects.

For ODBC applications that use NonStop ODBC Server object names, you must

duplicate those names by using the logical ANSI names in the SQL/MX environment

that match the names defined in the NonStop ODBC Server environment. All metadata

NonStop ODBC Server

3-part database name based on

SQL Server implementation

Corresponding SQL/MX

3-part database name based on

ANSI SQL 92 standard

Database name Catalog

Owner Schema

Object name Object name