This chapter describes the runtime arguments for the DDLGEN
utility. You enter the arguments at the command line when you run the utility. DDLGEN
provides instructions for generating table definitions for target databases based on existing Enscribe and SQL definitions.
For more information about using DDLGEN
, see the Administering Oracle GoldenGate for HP NonStop (Guardian).
TACL> RUN DDLGEN /IN [command_file]/ [-d file_name]
The DDLGEN
syntax shown above includes the following run-time arguments:
/IN
command_file
/If you have created and saved a file of your responses using the NonStop editor, you can enter the name of that file.
d
file_name
Instructs DDLGEN
to use the DEFGEN
definitions file file_name
.
Oracle GoldenGate includes a template for each supported database. The following arguments can be used in these templates. For more information about using templates, see the Administering Oracle GoldenGate for HP NonStop (Guardian).
Parameters | Description |
---|---|
OMITNULL | INCLUDENULLOMITNULL | INCLUDENULL |
Determines whether or not columns contain |
OMITNOTNULL | INCLUDENOTNULL |
Omits or includes |
OMITREDEFS | INCLUDEREDEFS |
Omits or includes fields that are redefines of other fields. |
OMITCOMMENTS | INCLUDECOMMENTS |
Omits or includes comments. |
USESAMENULLS |
Directs |
Use OMITNULL
and INCLUDENULL
to omit or include the word NULL
for columns that can contain null values. Assuming the column can be set to null, DDLGEN
outputs the following definitions:
If INCLUDENULL
(or nothing) is specified, the output is:
COL CHAR (10) NULL
If OMITNULL
is specified, the output is:
COL CHAR (10)
The default templates for each supported database already include the correct setting for this argument.
INCLUDENULL
OMITNULL | INCLUDENULL
Use OMITNOTNULL
and INCLUDENOTNULL
to omit or include the words NOT NULL
for columns that cannot contain null values. Assuming the column cannot be set to null, DDLGEN
outputs the following definitions:
If INCLUDENOTNULL
(or nothing) is specified:
COL CHAR (10) NOT NULL
If OMITNOTNULL
is specified:
COL CHAR (10)
The default templates for each supported database already include the correct setting for this argument.
INCLUDENOTNULL
OMITNOTNULL | INCLUDENOTNULL
Use OMITREDEFS
and INCLUDEREDEFS
to omit or include fields that redefine other fields in a source DDL definition in the output table definition.
INCLUDEREDEFS
OMITREDEFS | INCLUDREDEFS
Use OMITCOMMENTS
and INCLUDECOMMENTS
to omit or include comments regarding anomalies such as duplicate field names, arrays and other items that were transformed or need to be corrected manually.
INCLUDECOMMENTS
OMITCOMMENTS | INCLUDECOMMENTS