ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

ODBC/MX Client Overview
HP NonStop ODBC/MX Driver for Windows—691126-002
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>