MX 3.x)

ODBC/MX Client Overview

HP NonStop Open System Services ODBC/MX Client Driver—640328-001

1-6

Connection Mapping

MXCS maps the client data source name in an incoming connection request to the

server data source name (names are case sensitive). If the name matches but the

server data source is not started, the connection request is rejected. If the server data

source name does not exist, the Association Server routes the connection to the

default data source. If the default data source is not started, the connection request is

rejected.

After a data source name is assigned, the Association Server uses any MXCS SQL

server that is previously used by the same userid. If no such server is found, the

Association Server assigns the first available server to the connection and reinitializes

the user context to the one defined in the configuration for the data source name on

the server.

Object Naming and Mapping

ODBC/MX can access SQL database objects as follows:

•

with an alias, for SQL/MP objects that have an alias name (See ANSI Names for

SQL/MP Objects).

ANSI Name Type

ODBC/MX supports only ANSI name types for NonStop SQL objects.

Using the client interface at a client workstation, you can configure the default catalog

and schema names used to qualify the table names in queries.

The name format is as follows:

catalog.schema.object-name

ANSI names have a maximum of 128 characters for each part of the name (not

including the dots).

ANSI Names for SQL/MX Objects

ANSI names for SQL/MX objects are registered in SQL/MX metadata residing in

SQL/MX format tables.

ANSI Names for SQL/MP Objects

ANSI names (also called alias names) are logical names that map to physical

Guardian names of existing SQL/MP objects.

To add ANSI alias names for SQL/MP tables, use NSM/web or the MXCI command

CREATE SQLMP ALIAS, which stores the alias name in the MP_PARTITIONS table in

the SQL/MX catalog. The SQL/MX catalog and schema names must exist before you

create the alias name. You can add alias names for NonStop SQL tables that are