SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-102
mximportddl Utility
-MAPFILE or -MAP map-file-name
specifies the name of the MAP file. map-file-name must be a valid OSS file
name.
While importing the XML file, MAP file can be used to map the source catalog or
schema to a target catalog or schema. Also, the source node name and volume
can be mapped to the target node name and volume. The MAP file template can
be generated for the specific XML file, by specifying -PREPAREMAP in the
mximportddl utility.
A MAP file consists of multiple sections, which are listed below:
[CATALOG-MAPPING]
[SCHEMA-MAPPING]
[LOCATION-MAPPING]
These sections have the following keywords:
-XMLFILE or -XML xml-file-name
specifies the name of the XML file, which is generated by the mxexportddl utility.
The xml-file-name must be a valid OSS file name.
-STATS ON |OFF
specifies if the statistics of the tables needs to be imported. The default is ON.
ON
imports the statistics of the tables.
[CATALOG-MAPPING]
CATALOG <catalog name> = <New catalog name>;
. . .
[SCHEMA-MAPPING]
SCHEMA <catalog name>.<schema name> = <New catalog name>.<new
schema name>;
. . .
[LOCATION-MAPPING]
LOCATION <System name>.<volume name> = <New system name>.<new
volume name>;
. . .