SQL/MX Connectivity Service Manual (SQL/MX 2.x)

Contents
HP NonStop SQL/MX Connectivity Service Manual—524944-008
iii
3. Starting, Configuring, and Managing MXCS (continued)
3. Starting, Configuring, and Managing MXCS (continued)
Troubleshooting MFC 3-30
A. Migrating Applications from NonStop ODBC Server
Server-Side Migration Steps A-1
Server: Duplicating NonStop ODBC Server Logical Database Object Names A-2
Database Object Names A-2
ANSI Names A-3
Name Mapping A-3
CREATE SQLMP ALIAS Command A-4
Using SQL Scripts to Automate Name Mapping A-4
Accessing Migrated Names A-5
Server: Migrating NonStop ODBC Server Configuration Settings A-5
Comparison of Configuration Terms A-6
Resource Governing A-7
Setting Control Statements A-7
Configuring MXCS Data Sources A-8
Setting Network Attributes A-8
Setting MXCS Service Attributes A-9
Server: Preserving User Alias Settings A-9
Client-Side Migration Steps A-10
Client: Modifying Applications A-10
ODBC API calls A-11
Modifying SQL Statements A-13
Migrating SQL Server Objects A-13
Modifying Pass-Through Commands A-14
Features Not Supported A-14
NonStop ODBC Server Migration Example A-15
Server Characteristics A-15
System Catalog Names A-15
User Catalog Names A-17
Configuration Example for the NonStop ODBC Server A-20
Adding Aliases for System Catalog Object Names A-23
Adding Aliases for User Catalog Names A-24
Adding User Alias Names To Safeguard A-26
Running and Configuring MXCS A-26
Client Data Source Configuration A-27