MX 2.x)

ManualsBrandsHP ManualsServerHP NonStop G-Series

100

Migrating Applications from NonStop ODBC Server

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

A-23

Adding Aliases for System Catalog Object Names

To add NonStop ODBC Server system catalog object names to the SQL/MX

environment, use MXCI to execute the following commands:

CREATE CATALOG MASTER;

CREATE SCHEMA MASTER.DBO;

CREATE SQLMP ALIAS MASTER.DBO.BASETABS \TEST1.$DATA02.SYSCAT.BASETABS;

CREATE SQLMP ALIAS MASTER.DBO.CATALOGS \TEST1.$DATA02.SQL.CATALOGS;

CREATE SQLMP ALIAS MASTER.DBO.COLUMNS \TEST1.$DATA02.SYSCAT.COLUMNS;

CREATE SQLMP ALIAS MASTER.DBO.COMMENTS \TEST1.$DATA02.SYSCAT.COMMENTS;

CREATE SQLMP ALIAS MASTER.DBO.CONSTRNT \TEST1.$DATA02.SYSCAT.CONSTRNT;

CREATE SQLMP ALIAS MASTER.DBO.CPRLSRCE \TEST1.$DATA02.SYSCAT.CPRLSRCE;

CREATE SQLMP ALIAS MASTER.DBO.CPRULES \TEST1.$DATA02.SYSCAT.CPRULES;

CREATE SQLMP ALIAS MASTER.DBO.FILES \TEST1.$DATA02.SYSCAT.FILES;

CREATE SQLMP ALIAS MASTER.DBO.INDEXES \TEST1.$DATA02.SYSCAT.INDEXES;

CREATE SQLMP ALIAS MASTER.DBO.KEYS \TEST1.$DATA02.SYSCAT.KEYS;

CREATE SQLMP ALIAS MASTER.DBO.PARTNS \TEST1.$DATA02.SYSCAT.PARTNS;

CREATE SQLMP ALIAS MASTER.DBO.PROGRAMS \TEST1.$DATA02.SYSCAT.PROGRAMS;

CREATE SQLMP ALIAS MASTER.DBO.SYSCOLUMNS \TEST1.$DATA02.SYSCAT.ZVUCOL;

CREATE SQLMP ALIAS MASTER.DBO.SYSDATABASES \TEST1.$DATA02.SYSCAT.ZVSDB;

CREATE SQLMP ALIAS MASTER.DBO.SYSINDEXES \TEST1.$DATA02.SYSCAT.ZVUIX;

CREATE SQLMP ALIAS MASTER.DBO.SYSMESSAGES \TEST1.$DATA02.SYSCAT.ZVSMSG;

CREATE SQLMP ALIAS MASTER.DBO.SYSOBJECTS \TEST1.$DATA02.SYSCAT.ZVUOBJ;

CREATE SQLMP ALIAS MASTER.DBO.SYSPROTECTS \TEST1.$DATA02.SYSCAT.ZVUPROT;

CREATE SQLMP ALIAS MASTER.DBO.SYSTYPES \TEST1.$DATA02.SYSCAT.ZVUDT;

CREATE SQLMP ALIAS MASTER.DBO.SYSUSERS \TEST1.$DATA02.SYSCAT.ZVUUS;

CREATE SQLMP ALIAS MASTER.DBO.TABLES \TEST1.$DATA02.SYSCAT.TABLES;

CREATE SQLMP ALIAS MASTER.DBO.TRANSIDS \TEST1.$DATA02.SYSCAT.TRANSIDS;

CREATE SQLMP ALIAS MASTER.DBO.USAGES \TEST1.$DATA02.SYSCAT.USAGES;

CREATE SQLMP ALIAS MASTER.DBO.VERSIONS \TEST1.$DATA02.SYSCAT.VERSIONS;

CREATE SQLMP ALIAS MASTER.DBO.VIEWS \TEST1.$DATA02.SYSCAT.VIEWS;

CREATE SQLMP ALIAS MASTER.DBO.ZNSALT \TEST1.$DATA02.SYSCAT.ZNSALT;

CREATE SQLMP ALIAS MASTER.DBO.ZNSCON \TEST1.$DATA02.SYSCAT.ZNSCON;

CREATE SQLMP ALIAS MASTER.DBO.ZNSDB \TEST1.$DATA02.SYSCAT.ZNSDB;

CREATE SQLMP ALIAS MASTER.DBO.ZNSDEF \TEST1.$DATA02.SYSCAT.ZNSDEF;

CREATE SQLMP ALIAS MASTER.DBO.ZNSDUMMY \TEST1.$DATA02.SYSCAT.ZNSDUMMY;

CREATE SQLMP ALIAS MASTER.DBO.ZNSGOV \TEST1.$DATA02.SYSCAT.ZNSGOV;

CREATE SQLMP ALIAS MASTER.DBO.ZNSMSG \TEST1.$DATA02.SYSCAT.ZNSMSG;

CREATE SQLMP ALIAS MASTER.DBO.ZNSNET \TEST1.$DATA02.SYSCAT.ZNSNET;

QST_MODE_ON N

SQL_ACCESS_MODE RW

SQL_CURSOR_MODE RW

SQL_DIALECT TDM_CORE

SQL_MAX_STATEMENT_CACHE 0

SQL_TXN_ISOLATION 1

SQL_UNSUPPORTED E

OBJ_NAME_CACHE Y

STMT_CACHE_LEVEL 1

CON_MODE_ON N

CON_NAME

CLOSE_TABLES_PER_SESSION N

PROFILE_NAME NSOADMINPROF