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

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series

NSOADMINPROFPROFILE_NAME

NNNUDEFAULT_SECURITY

TRA_MODE_ON

TRA_NAME

NACC_MODE_ON

ACC_LOGTABLE_NAME

SESSIONACC_LEVEL

NGOV_MODE_ON

GOV_NAME

NQST_MODE_ON

RWSQL_ACCESS_MODE

RWSQL_CURSOR_MODE

TDM_CORESQL_DIALECT

0SQL_MAX_STATEMENT_CACHE

1SQL_TXN_ISOLATION

ESQL_UNSUPPORTED

YOBJ_NAME_CACHE

1STMT_CACHE_LEVEL

NCON_MODE_ON

CON_NAME

NCLOSE_TABLES_PER_SESSION

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;

72 Migrating Applications from NonStop ODBC Server