SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Using Guardian Names With TMF, RDF, and
Measure
HP NonStop SQL/MX Installation and Management Guide—523723-004
B-2
MXGNAMES Input Files
MXGNAMES Input Files
MXGNAMES uses the same information that is provided by SHOWDDL, which always
includes all partitions of the base table and all implicitly and explicitly defined indexes
on the table. This information constitutes the entire set of files that would have to be
recovered or restored to replace all objects described in the SHOWDDL text.
General Characteristics of EDIT Files
The inputs and outputs of MXGNAMES are standard Guardian EDIT files with:
•
Guardian file code of 101
•
Maximum line length of 239 characters
For readability, MXGNAMES limits output lines to 80 characters.
Other tools or programs can be used to capture data for later use with MXGNAMES.
Any such file to be used as input to MXGNAMES might have to be converted to the
Guardian format to be compatible with MXGNAMES. Tools such as CTOEDIT can be
used in these conversions.
SQL Names File
The input SQL names file is an EDIT format file used in conjunction with the
-SQLNames command-line option. It consists of a list of fully qualified ANSI table
names, one per line.
SHOWDDL File
SHOWDDL output is commonly saved to an OSS format text file, which has to be
converted using CTOEDIT before being used as input to MXGNAMES.
MXGNAMES Output Files
If MXGNAMES generates multiple output files, duplicate file names can result. To help
avoid such problems:
•
Specify shorter file names so that extra digits can be appended without overwriting
characters from the original name.
Note. Because of the 239-character limit for EDIT files, MXGNAMES cannot support table
names in the input file whose overall length is greater than 239 characters, including the dots
separating the catalog, schema, and table name portions. Such names have to be specified
individually on the MXGNAMES command line.
Note. The SHOWDDL file cannot be converted to an EDIT file if it contains an ANSI table
name whose overall length is greater than 239 characters, including the dots separating the
catalog, schema, and table name portions. Such names have to be removed from the file, and
submitted individually to MXGNAMES by the command line.