SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-63
mxexportddl Utility
mxexportddl Utility
Considerations for mxexportddl
mxexportddl is an OSS command-line utility that captures user SQL/MX metadata
and saves it in XML format. This utility supports OSS large files (files greater than 2
GB) as output files. .
mxexportddl
must be lowercase.
-I input-table-name
specifies the fully qualified name for the SQL/MX Release 2.x table whose
metadata is to be imported. The form of the name is catalog-name.schema-
name.table-name, where each part is an SQL identifier. If you do not specify the
catalog and schema parts of the source-table, mxexportddl uses the default
catalog and schema values for that session. Delimited names are supported.
You must specify either -I or -S or mxexportddl terminates.
-S catalog-name.schema-name
is the name of an SQL/MX Release 2.0 or greater catalog and schema whose
metadata is to be exported. It is an ANSI logical name of the form:
[[catalog-name.]schema-name]
where each part of the name is a valid SQL identifier with a maximum of 128
characters. For more information, see Identifiers on page 6-52 and Database
Object Names on page 6-12
If you are using delimited names, mxexportddl requires a '\"' 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.
Information on all tables, stored procedures, and SQL/MP alias objects from the
specified catalog is exported.
-H
directs mxexportddl to display syntax and quit.
mxexportddl {-I input-table-name
| -S catalog-name.schema-name
| -H}
[-O export-metadata-file-name] [-C]