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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-66
MXGNAMES Utility
SQLMX-table-name
is a single fully qualified SQLMX table name entered directly on the command line
output-format
indicates what subsystem the output file is to be used with:
-BR2
indicates output should be formatted for use with the BR2 RESTORE
command.
The resulting LOCATION clauses contain both the complete source and target
file names, where the target node-name specified in the -node option is
substituted in the target location, and the target volume, subvolume and file
name match the source exactly.
-TMF
indicates output should be formatted for use with TMF.
TMF has limits on the size of a command file. The maximum size of a
command file is 28,000 bytes. You can use the -length option to control the
size of the output file, while allowing for other text to be manually added to the
command file without exceeding the 28,000 byte limit.
Resource forks must be explicitly dumped and recovered. Therefore, the
output contains file names listed as wild cards that include the resource forks.
node-name
indicates what node name, including the backslash, should be appended to the
target location for the RESTORE command. If output-format is -BR2, this
argument is required. If output-format is -TMF, this option is ignored.
file-length
is an integer representing the maximum size of the output file in bytes. If the total
amount of data exceeds this amount, MXGNAMES generates additional files by
appending numbers to the output file name, truncating the output file name, if
necessary. If you do not specify the -length option, all output is placed in a single
file. The value you specify for file-length must be at least 1000.
-nocomment
indicates that no comments are to be included in the output file. TMF commands
allow comments in the text, which is the default if the output-format is -TMF. If
the output format is -BR2, no comments are included, regardless of whether you
specify -nocomment.