MX Release 3.2 (H06.25+, J06.14+)

Column HeadMXCS EquivalentsNonStop ODBC Server Pass-Through Commands

table logical names using the DROP SQLMP ALIAS

command.

If the SQL/MX language supports the commands, they can

be sent directly. CONTROL statements defined in SQL/MX

can also be sent (no special syntax is required).

SET commands for setting environment variables

Features Not Supported

The following NonStop ODBC Server features are not supported:

• DBLib messages using the TDS transport. To work around this, you can use an intermediate

gateway to convert TDS messages to ODBC calls.

• IPX/SPX and Named Pipes network protocols. To work around this, you can use an intermediate

gateway to convert protocols to TCP/IP.

NonStop ODBC Server Migration Example

Server Characteristics

In this example, the server has the following characteristics:

\TEST.$DATA02.SYSCATSystem Catalog:

\TEST.$DATA07.SAMDBCAUser Catalog:

\TEST.$DATA04.PERSNL.EMPLOYEEUser Tables:

\TEST.$DATA04.PERSNL.JOB

\TEST.$DATA04.PERSNL.DEPT

\TEST.$DATA04.PERSNL.MGRLIST

DBAGR.PRSNLTable owner

ODBCUSR1, which is mapped to the user ID SQLUSR.USER1NonStop ODBC Server users:

and

ODBCUSR2, which is mapped to the user ID SQLUSR.USER2.

System Catalog Names

Guardian NameObject NameOwner NameDatabase Name

\TEST.$DATA02.SYSCAT.BASETABSBASETABSDBOMASTER

\TEST.$DATA02.SQL.CATALOGSCATALOGSDBOMASTER

\TEST.$DATA02.SYSCAT.COLUMNSCOLUMNSDBOMASTER

\TEST.$DATA02.SYSCAT.COMMENTSCOMMENTSDBOMASTER

\TEST.$DATA02.SYSCAT.CONSTRNTCONSTRNTDBOMASTER

\TEST.$DATA02.SYSCAT.CPRLSRCECPRLSRCEDBOMASTER

\TEST.$DATA02.SYSCAT.CPRULESCPRULESDBOMASTER

\TEST.$DATA02.SYSCAT.FILESFILESDBOMASTER

\TEST.$DATA02.SYSCAT.INDEXESINDEXESDBOMASTER

\TEST.$DATA02.SYSCAT.KEYSKEYSDBOMASTER

\TEST.$DATA02.SYSCAT.PARTNSPARTNSDBOMASTER

\TEST.$DATA02.SYSCAT.PROGRAMSPROGRAMSDBOMASTER

\TEST.$DATA02.SYSCAT.ZVUCOLSYSCOLUMNSDBOMASTER

\TEST.$DATA02.SYSCAT.ZVSDBSYSDATABASESDBOMASTER

66 Migrating Applications from NonStop ODBC Server