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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-101
mximportddl Utility
( 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.
-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 imported. 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 ' \" ', the osh shell strips
the required ' " ' characters.
If sqlmx-object-spec-list is not provided, all the SQL/MX objects in the
XML file will be imported.
-CONSTRAINTS ON | OFF
specifies if droppable constraints need to be imported. The default is ON.
ON
imports the droppable and non-droppable constraints of the table.
OFF
imports only the non-droppable constraints of the table.
-LOGFILE or -LOG log-file-name
redirects the screen logs of the mximportddl utility into an OSS file. The
log-file-name must be a valid OSS file name.