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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-89
mxexportddl Utility
•
A constraint cannot be specified explicitly in the mxexportddl utility. To export a
constraint, the table including the constraint must be exported. The constraints that
are exported vary depending on whether the CONSTRAINTS option is set to ON or
OFF.
•
Views can be implicitly exported with the entire schema and not only by the table.
•
System defaults are always exported.
mxexportddl
must be lowercase.
-HELP
directs mxexportddl to display the syntax.
sqlmx-object-spec-list
is the list of SQL/MX object names with their corresponding object types. The
sqlmx-object-spec-list can be specified as:
( sqlmx-object-type sqlmx-object-name-list
[ sqlmx-object-type sqlmx-object-name-list] ... )
The sqlmx-object-type is one of these object types:
{ -CAT | -CATALOG }
{ -SCH | -SCHEMA }
{ -TAB | -TABLE }
-CAT | -CATALOG
is the object type for a catalog.
-SCH | -SCHEMA
is the object type for a schema.
mxexportddl
-HELP
|
{
sqlmx-object-spec-list
-XMLFILE xml-file-name
[-CONSTRAINTS ON | OFF]
[-LOGFILE log-file-name]
[-STATS ON | OFF ]
[-CLEAR ON | OFF ]
}