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_nameInstructs 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