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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-44
Considerations for migrate
ALL
migrates all entries in the MPALIAS, DEFAULTS, ODBC (MXCS), and PROCS
metadata tables. The default is ALL.
MPALIAS
migrates entries in the MPALIAS metadata table.
DEFAULTS
migrates entries in the DEFAULTS metadata table.
ODBC
migrates entries in the OCBC (MXCS) ZONAM2ID, ZOAS2DS, ZODS,
ZOENV, and ZORES metadata tables.
PROCS
migrates entries in the PROCS metadata table.
SCRIPT
migrates only those entries in the script file. You cannot use the other
EXECUTE options when you use SCRIPT.
ERROR_LOG
captures entries that fail to migrate.
OSS-filename
specifies the name of the ERROR_LOG text file.
If you specify ERROR_LOG without naming a text file, migrate creates a
file named errlog.out.
If an error log file of the same name already exists (for example, from a
prior run) and you do not specify the CLEAR option, migrate uses
errlog.out.
CLEAR
uses the existing error log file and deletes the contents.
Considerations for migrate
Security Considerations
You must be the super ID to migrate the metadata of a schema. Any user can execute
the PRELIMINARY_REPORT option.