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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-103
mximportddl Utility
OFF
does not import the statistics of the tables. Only the metadata of the SQL/MX
objects is imported.
-CLEAR ON |OFF
specifies if the mximportddl utility can overwrite the specified MAP file if it
already exists and -PREPAREMAP is provided. The default is OFF.
ON
overwrites the specified MAP file if it already exists.
OFF
does not overwrite the specified MAP file. If the file already exists, the write
operation fails.
-KEEPDDL ON | OFF
specifies whether the mximportddl utility should retain the target tables and its
corresponding indexes if it already exists. The default is ON.
ON
imports the metadata of table and its indexes only if the target table does not
exist. If the target table exists, physical statistics (index level, nonempty block
count, and EOF) will not be imported regardless of the KEEPSTATS option
value.
OFF
imports the metadata even if the target table already exists. The existing table
and its indexes will be dropped, before creating the table. The existing
statistics will also be deleted. The KEEPDDL OFF option will override the
KEEPSTATS ON option.
-KEEPGFN ON | OFF
specifies whether the Guardian file names of table and index partitions must be
retained by the mximportddl utility. The default is ON.
ON
imports the partitions with same Guardian file names as in the original table.
OFF
imports the partitions with SQL/MX generated Guardian file names.