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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-90
mxexportddl Utility
-TAB | -TABLE
is the object type for a table.
The sqlmx-object-name-list is:
( sqlmx-object-name [sqlmx-object-name] ... )
sqlmx-object-name is a fully-qualified SQL/MX object name of the
specified sqlmx-object-type. The specified object and all subordinate
objects are exported. Wild cards are not permitted in the
sqlmx-object-name. For delimited names, use ' \" ' to represent a
quote. If a schema is "CATALOG"."SCHEMA", you must represent the
schema as \"CATALOG\".\"SCHEMA\". If you do not use ' \" ', the osh shell
strips the required ' " ' characters.
-XMLFILE 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.
-CONSTRAINTS ON | OFF
specifies whether droppable constraints need to be exported or not. The default is
ON.
ON
exports the droppable and non-droppable constraints of the table.
OFF
exports only the non-droppable constraints of the table.
-LOGFILE log-file-name
redirects the screen logs of the mxexportddl utility into an OSS file. The
log-file-name must be a valid OSS file name.
-STATS ON |OFF
specifies if the statistics of the tables needs to be exported. The default is ON.
ON
exports the statistics of the tables.
OFF
does not export the statistics of the tables. Only the metadata of the SQL/MX
objects is exported.