MX 2.x)

Migrating Applications from NonStop ODBC Server

HP NonStop SQL/MX Connectivity Service Manual—524944-008

A-15

NonStop ODBC Server Migration Example

Server Characteristics

In this example, the server has the following characteristics:

System Catalog Names

System Catalog: \TEST.$DATA02.SYSCAT

User Catalog: \TEST.$DATA07.SAMDBCAT

User Tables: \TEST.$DATA04.PERSNL.EMPLOYEE

\TEST.$DATA04.PERSNL.JOB

\TEST.$DATA04.PERSNL.DEPT

\TEST.$DATA04.PERSNL.MGRLIST

Table owner DBAGR.PRSNL

NonStop ODBC

Server users:

ODBCUSR1, which is mapped to the user ID SQLUSR.USER1

and

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

Database

Name

Owner

Name Object Name Guardian Name

MASTER DBO BASETABS \TEST.$DATA02.SYSCAT.BASETABS

MASTER DBO CATALOGS \TEST.$DATA02.SQL.CATALOGS

MASTER DBO COLUMNS \TEST.$DATA02.SYSCAT.COLUMNS

MASTER DBO COMMENTS \TEST.$DATA02.SYSCAT.COMMENTS

MASTER DBO CONSTRNT \TEST.$DATA02.SYSCAT.CONSTRNT

MASTER DBO CPRLSRCE \TEST.$DATA02.SYSCAT.CPRLSRCE

MASTER DBO CPRULES \TEST.$DATA02.SYSCAT.CPRULES

MASTER DBO FILES \TEST.$DATA02.SYSCAT.FILES

MASTER DBO INDEXES \TEST.$DATA02.SYSCAT.INDEXES

MASTER DBO KEYS \TEST.$DATA02.SYSCAT.KEYS

MASTER DBO PARTNS \TEST.$DATA02.SYSCAT.PARTNS

MASTER DBO PROGRAMS \TEST.$DATA02.SYSCAT.PROGRAMS

MASTER DBO SYSCOLUMNS \TEST.$DATA02.SYSCAT.ZVUCOL

MASTER DBO SYSDATABASES \TEST.$DATA02.SYSCAT.ZVSDB

MASTER DBO SYSINDEXES \TEST.$DATA02.SYSCAT.ZVUIX

MASTER DBO SYSMESSAGES \TEST.$DATA02.SYSCAT.ZVSMSG

MASTER DBO SYSOBJECTS \TEST.$DATA02.SYSCAT.ZVUOBJ

MASTER DBO SYSPROTECTS \TEST.$DATA02.SYSCAT.ZVUPROT