6 DDLGEN Arguments
DDLGEN
utility. These arguments are entered at the command line when you run the utility. DDLGEN
utility provides instructions for generating table definitions for target databases based on existing Enscribe and SQL definitions. For more information about using DDLGEN
, see Creating Target Database DDL.
Run-time arguments
Syntax
TACL> RUN DDLGEN /IN [command_file
]/ [-dfile_name
]
The DDLGEN
syntax shown above includes the following run-time arguments:
OMITNULL | INCLUDENULL
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.
Default
INCLUDENULL
Syntax
OMITNULL | INCLUDENULL
OMITNOTNULL | INCLUDENOTNULL
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.
Default
INCLUDENOTNULL
Syntax
OMITNOTNULL | INCLUDENOTNULL
OMITREDEFS | INCLUDEREDEFS
Use OMITREDEFS
and INCLUDEREDEFS
to omit or include fields that redefine other fields in a source DDL definition in the output table definition.
Default
INCLUDEREDEFS
Syntax
OMITREDEFS | INCLUDREDEFS
OMITCOMMENTS | INCLUDECOMMENTS
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.
Default
INCLUDECOMMENTS
Syntax
OMITCOMMENTS | INCLUDECOMMENTS