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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-99
mximportddl Utility
mximportddl Utility
Considerations for mximportddl
Examples of mximportddl
mximportddl is an OSS command-line utility that replicates the DDL definition and
statistics of SQL/MX objects.
It is used to import the:
•
SQL/MX object metadata from an XML file for DDL replication
•
SQL/MX table statistics from an XML file for statistics replication
Importing Metadata and Statistics of SQL/MX Objects
A catalog is a logical object; it is a collection of schemas. A schema is a logical object
that has a collection of database objects such as tables, indexes, views, and stored
procedures.
•
Importing a catalog includes importing all the subordinate objects in its hierarchy
such as schemas, tables, and the subordinate objects of the tables.
•
Importing a schema includes importing all its subordinate tables, views, and stored
procedures.
•
Importing a table includes:
°
Non-droppable constraints
°
Droppable constraints unless the CONSTRAINTS OFF option is enabled
°
All table partitions excluding data
°
All indexes and index partitions excluding data
°
All triggers and referential integrity constraints
°
Statistics of the table unless the STATS OFF option is enabled
•
Indexes cannot be specified explicitly in the mximportddl utility. They are
subordinate to the table object and can only be imported with the parent table.
•
A constraint cannot be explicitly specified in the mximportddl utility. To import a
constraint, the table including the constraint must be imported. The constraints that
are imported vary depending on whether the CONSTRAINTS option is set to ON or
OFF.
Note. The mximportddl utility is available only on systems running J06.07 and later J-
series RVUs and H06.18 and later H-series RVUs.