SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-43
migrate Utility
SHOW
displays existing entries from the SQL/MP metadata tables.
ALL
displays all entries in the MPALIAS, DEFAULTS, ODBC (MXCS), and PROCS
metadata tables. The default is ALL.
MPALIAS
displays the names of all the entries in the MPALIAS metadata table.
DEFAULTS
displays the names of all the entries in the DEFAULTS metadata table.
ODBC
displays the names of all the entries in the ODBC (MXCS) metadata tables:
ZONAM2ID, ZOAS2DS, ZODS, ZOENV, and ZORES.
PROCS
displays all the entries in the PROCS metadata table.
SCRIPT
creates a text file that allows you to eliminate or modify entries. The SCRIPT
file contains the CREATE SQLMP ALIAS, INSERT, and CREATE
PROCEDURE statements necessary for each entry. Modification of entries can
include renaming catalogs, schemas, SQL/MP tables, stored procedure labels,
and Java class or JAR files.
OSS-filename
specifies the name of the SCRIPT text file.
If you specify SCRIPT without naming a text file, migrate creates a file
named script.out.
If a script file of the same name already exists (for example, from a prior
run) and you do not specify the CLEAR option, migrate uses
script.out.
CLEAR
uses the existing script file and deletes the contents.
EXECUTE
migrates the designated entries in the script file.