MX 2.x)

ODBC/MX Client Overview

HP NonStop ODBC/MX Driver for Windows—527888-004

1-7

Password Expiration

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

registered in different NonStop SQL user catalogs, using the same SQL/MX catalog

and schema names.

Password Expiration

If MXCS on the NonStop system is configured to allow the driver to display password

expiration warnings, you can change your password during the current session, in one

of two ways.

•

Provide the old and new passwords in a dialog box that displays with the expiration

warning. If you enter an invalid password, the connection is terminated.

You can also cancel the password change and just continue with the current

session.

•

Provide the old and new passwords in the connection string:

PWD=<old_password>,<new_password>,<new_password>