SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-61
MXGNAMES Utility
MXGNAMES Utility
Considerations for MXGNAMES
Examples of MXGNAMES
MXGNAMES is a Guardian program that is run from a TACL prompt or an OBEY
command file.
It converts one or more ANSI table names into a list of corresponding Guardian file
names, appropriately formatted for TMF or BACKUP/RESTORE 2.
output-file-name
is the name of a nonexistent Guardian disk file to which the output should be
written. If you do not specify an output file, output is written to the screen. If the file
already exists, or cannot be created, an error is returned.
SQL-table-name-list-file
is an EDIT format file that consists of a list of a list of fully qualified ANSI table
names, one per line. MXGNAMES ignores blank lines.
Because of the 255 character limit for EDIT files, MXGNAMES cannot support
table names in the file whose overall length is greater than 255 characters,
including the dots separating the catalog, schema, and table name portions. You
must specify such names individually on the MXGNAMES command line.
SHOWDDL-file-name
is an EDIT file to be used as input that contains SHOWDDL output for one SQLMX
table.
SHOWDDL output is normally saved to an OSS format text file. You must use
CTOEDIT to convert this file to an EDIT file before you can use it as input to
MXGNAMES. You cannot convert the SHOWDDL file to an EDIT file if it contains
an ANSI table name whose overall length is greater than 255 characters, including
the dots separating the catalog, schema, and table name portions. You must
specify such names individually on the MXGNAMES command line.
MXGNAMES -HELP |
input [-output=output-file-name] output-format
[-node=node-name] [-length=file-length] [-nocomment]
input is
-SQLnames=SQL-table-name-list-file
| -Showddl=SHOWDDL-file-name
| SQLMX-table-name
output-format is
-BR2
-TMF