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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-100
mximportddl Utility
•
Referential integrity constraints, views, triggers, and stored procedures are referred
to as dependency objects. The dependency objects are imported at the end of the
mximportddl utility to ensure that all parent objects are imported in advance.
•
The SHOWDDL ON and SHOWDDLLOC options are provided, the DDL of
dependency objects will be written to OSS files. This can be used to manually
create the objects later. Dependency objects will not be imported.
•
Views can be implicitly imported with the entire schema and not only by the table.
•
System defaults are not imported.
mximportddl
must be lowercase.
-HELP
directs mximportddl 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 is specified as:
mximportddl
-HELP
|
{
-XMLFILE xml-file-name
[sqlmx-object-spec-list]
[-MAPFILE map-file-name]
[-CONSTRAINTS ON | OFF]
[-LISTONLY ON | OFF]
[-LOGFILE log-file-name]
[-STATS ON | OFF ]
[-KEEPSTATS ON | OFF]
[-KEEPDDL ON | OFF]
[-KEEPGFN ON | OFF]
[-SHOWDDL ON | OFF]
[-SHOWDDLLOC oss-directory]
}
|
{
-PREPAREMAP
-XMLFILE xml-file-name
-MAPFILE map-file-name
[-LOGFILE log-file-name]
[-CLEAR ON | OFF ]
}