MX Release 3.2.1 (H06.26+, J06.15+)

Object naming and mapping

The driver can access SQL/MX database objects and SQL/MP objects that have an alias.

ANSI name type

Only ANSI name types are supported for SQL/MX database objects. You can configure the default

catalog and schema names to be used to qualify table names in the queries. The name format is:

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 database objects are registered in the metadata in SQL/MX tables.

ANSI alias names for SQL/MP objects

Alias names are logical names that map to physical Guardian names for existing SQL/MP objects.

To add ANSI alias names for SQL/MP tables, use the command CREATE SQLMP ALIAS, which

stores the alias name in the SQL/MX catalog. For more information about CREATE SQLMP ALIAS

command, see the SQL/MX 3.x Reference Manual.

Unsupported ODBC APIs

The Linux ODBC/MX Client Driver is ODBC 3.5 compliant. Table 2 (page 14) lists the unsupported

ODBC APIs.

Object naming and mapping 13