Votes - , Average rating:
(
)
)
Manafacture: HP
File size: 334.53 kb
File name:
Language of manual:
The document is loading, please wait
 |
The document is loading, please wait
Other manuals for this model:
Desktops - HP Integrity NonStop H-Series (1.98 mb)
Desktops - HP Integrity NonStop H-Series (16.73 mb)
Desktops - HP Integrity NonStop H-Series (957.56 kb)
Desktops - HP Integrity NonStop H-Series (2.38 mb)
Desktops - HP Integrity NonStop H-Series (881.66 kb)
Desktops - HP Integrity NonStop H-Series (965.62 kb)
Desktops - HP Integrity NonStop H-Series (676.93 kb)
Desktops - HP Integrity NonStop H-Series (393.72 kb)
Desktops - HP Integrity NonStop H-Series (776.57 kb)
manual abstract
Migrating Applications from NonStop ODBC Server
Adding Aliases for User Catalog Names
CREATE SQLMP ALIAS MASTER.DBO.ZNSPROF \TEST1.$DATA02.SYSCAT.ZNSPROF;
CREATE SQLMP ALIAS MASTER.DBO.ZNSPROT \TEST1.$DATA02.SYSCAT.ZNSPROT;
CREATE SQLMP ALIAS MASTER.DBO.ZNSSCFG \TEST1.$DATA02.SYSCAT.ZNSSCFG;
CREATE SQLMP ALIAS MASTER.DBO.ZNSSCS \TEST1.$DATA02.SYSCAT.ZNSSCS;
CREATE SQLMP ALIAS MASTER.DBO.ZNSSER \TEST1.$DATA02.SYSCAT.ZNSSER;
CREATE SQLMP ALIAS MASTER.DBO.ZNSSMAP \TEST1.$DATA02.SYSCAT.ZNSSMAP;
CREATE SQLMP ALIAS MASTER.DBO.ZNSTRA \TEST1.$DATA02.SYSCAT.ZNSTRA;
CREATE SQLMP ALIAS MASTER.DBO.ZNSUMAP \TEST1.$DATA02.SYSCAT.ZNSUMAP;
CREATE SQLMP ALIAS MASTER.DBO.ZNSUS \TEST1.$DATA02.SYSCAT.ZNSUS;
CREATE SQLMP ALIAS MASTER.DBO.ZNSVALUE \TEST1.$DATA02.SYSCAT.ZNSVALUE;
CREATE SQLMP ALIAS MASTER.DBO.ZNUDT \TEST1.$DATA02.SYSCAT.ZNUDT;
CREATE SQLMP ALIAS MASTER.DBO.ZNUIX \TEST1.$DATA02.SYSCAT.ZNUIX;
CREATE SQLMP ALIAS MASTER.DBO.ZNUOBJ \TEST1.$DATA02.SYSCAT.ZNUOBJ;
CREATE SQLMP ALIAS MASTER.DBO.ZNUPCOL \TEST1.$DATA02.SYSCAT.ZNUPCOL;
CREATE SQLMP ALIAS MASTER.DBO.ZNUPROC \TEST1.$DATA02.SYSCAT.ZNUPROC;
CREATE SQLMP ALIAS MASTER.DBO.ZVUOCOL \TEST1.$DATA02.SYSCAT.ZVUOCOL;
CREATE SQLMP ALIAS MASTER.DBO.ZVUPCOL \TEST1.$DATA02.SYSCAT.ZVUPCOL;
CREATE SQLMP ALIAS MASTER.DBO.CUSTOMER \TEST1.$DATA02.SYSCAT.CUSTOMER;
CREATE SQLMP ALIAS MASTER.DBO.MP_PARTITIONS
\TEST1.$DATA02.SYSCAT.MP_PARTITIONS;
CREATE SQLMP ALIAS MASTER.DBO.TEMP3 \TEST1.$DATA02.SYSCAT.TEMP3;
CREATE SQLMP ALIAS MASTER.DBO.ZOAS2DS \TEST1.$DATA02.SYSCAT.ZOAS2DS;
CREATE SQLMP ALIAS MASTER.DBO.ZODS \TEST1.$DATA02.SYSCAT.ZODS;
CREATE SQLMP ALIAS MASTER.DBO.ZODT \TEST1.$DATA02.SYSCAT.ZODT;
CREATE SQLMP ALIAS MASTER.DBO.ZOENV \TEST1.$DATA02.SYSCAT.ZOENV;
CREATE SQLMP ALIAS MASTER.DBO.ZONAM2ID \TEST1.$DATA02.SYSCAT.ZONAM2ID;
CREATE SQLMP ALIAS MASTER.DBO.ZORES \TEST1.$DATA02.SYSCAT.ZORES;
CREATE SQLMP ALIAS MASTER.DBO.ZTEST \TEST1.$DATA02.SYSCAT.ZTEST;
Adding Aliases for User Catalog Names
To add user catalog names, create a script for MXCI that contains the following
commands:
CREATE CATALOG TEST_DATA07_SAMDBCAT;
CREATE SCHEMA TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.BASETABS
\TEST.$DATA07.SAMDBCAT.BASETABS;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.COLUMNS
\TEST.$DATA07.SAMDBCAT.COLUMNS ;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.COMMENTS
\TEST.$DATA07.SAMDBCAT.COMMENTS;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.CONSTRNT
\TEST.$DATA07.SAMDBCAT.CONSTRNT;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.CPRLSRCE
\TEST.$DATA07.SAMDBCAT.CPRLSRCE;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.CPRULES
\TEST.$DATA07.SAMDBCAT.CPRULES ;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.FILES
\TEST.$DATA07.SAMDBCAT.FILES;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.INDEXES
\TEST.$DATA07.SAMDBCAT.INDEXES ;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.KEYS
\TEST.$DATA07.SAMDBCAT.KEYS;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.PARTNS
\TEST.$DATA07.SAMDBCAT.PARTNS;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.PROGRAMS
\TEST.$DATA07.SAMDBCAT.PROGRAMS;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.SYSCOLUMNS
\TEST.$DATA07.SAMDBCAT.ZVUCOL;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.SYSINDEXES
\TEST.$DATA07.SAMDBCAT.ZVUIX;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.SYSOBJECTS
\TEST.$DATA07.SAMDBCAT.ZVUOBJ;
CREATE SQLMP ALIAS TEST_DATA07_SAMDBCAT.DBAGRP_PRSNL.SYSPROTECTS
HP NonStop SQL/MX Connectivity Service Manual for SQL/MX Release 3.1—663856-001
A-24
...Other models in this manual:
Desktops - HP Integrity NonStop J-Series (334.53 kb)