Login:
  • Home
  • →
  • Desktops
  • →
  • Free manual HP   HP Integrity NonStop H-Series
Votes - 0, Average rating: 0 ( )

User manual HP, model HP Integrity NonStop H-Series

Manafacture: HP
File size: 334.53 kb
File name:
Language of manual:en
Free link for this manual available at the bottom of the page



Other manuals for this model:

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)

Reviews



Your review
Your name:
Please, enter two numbers from picture:
capcha





Category