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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-104
mximportddl Utility
-KEEPSTATS ON | OFF
specifies whether the mximportddl utility should retain the statistics of target
tables if they already exist. The default is ON.
ON
imports the statistics only if the target table does not have statistics.
OFF
imports the statistics even if the target table already has statistics. The existing
statistics will be deleted before importing the statistics.
-LISTONLY ON | OFF
lists the SQL/MX objects in the specified XML file. Object is not imported. The
default is OFF.
ON
lists the objects in the XML file that matches the specified sqlmx-objects-
spec-list. The specified SQL/MX objects are not imported and will not
display the statistics details.
OFF
imports the specified SQL/MX objects.
-SHOWDDL ON | OFF
generates OSS files containing DDL information of dependency objects. The
default is OFF.
ON
generates one or more OSS files containing DDL information of dependency
objects. These files are created in addition to the objects that are normally
imported.
OFF
does not generate OSS files containing DDL information of dependency
objects.
Guidelines
•
If SHOWDDL ON is specified, the SHOWDDLLOC option also needs to be
specified.
•
The DDL information can be used to manually create triggers, views,
referential integrity constraints, and stored procedures after importing the