SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
5-74
Examples of mximportddl
•
Table statistics that includes physical statistics (index level, nonempty block count,
and EOF), histograms, and histogram intervals
•
Referential integrity constraints, views, triggers, and stored procedures
•
For a table containing the IDENTITY column, the internal Sequence Generator
attributes will also be stored in the XML file
Not Supported by mximportddl
•
System defaults
•
SQL/MP tables and aliases
Examples of mximportddl
•
To import the catalog cat1 and schema cat2.sch1 and cat2.sch2:
mximportddl -cat cat1 -sch cat2.sch1 cat2.sch2 -xml
export.xml
•
To import the catalog cat1 without statistics:
mximportddl -cat cat1 -xml export.xml -stats off
•
To import all the SQL/MX objects existing in the XML file:
mximportddl -xml export.xml
•
To generate the MAP file template from the XML file:
mximportddl -preparemap -xml export.xml -map export.map
The sample MAP FILE is shown below:
@CURRENTNODE will be replaced by the system name in which the mximportddl
utility is running.
•
To import the SQL/MX objects to a different target using map file:
mximportddl -xml export.xml -map export.map -cat cat1 cat2
[CATALOG-MAPPING]
CATALOG CAT1 = NCAT1;
[SCHEMA-MAPPING]
SCHEMA CAT2.SCH1 = NCAT3.NSCH;
[LOCATION-MAPPING]
LOCATION \NSK.$DATA1 = @CURRENTNODE.$DATA03;
LOCATION \NSK.$DATA2 = @CURRENTNODE.$DATA04;
LOCATION \NSK.$DATA3 = @CURRENTNODE.$DATA05;
LOCATION \NSK.$DATA4 = \DEV5.$DATA06;