Choose an SQL termination character |
Sets the character that will be used as the termination
character for SQL statements. |
Maximum parser errors for diagnosis |
Sets the maximum number of parser errors that are reported
when an SQL script file is opened. The value must be an integer that is greater
than 0. When SQL script files are large, it can be helpful to limit the number
of errors that are diagnosed. |
Maximum parser time for diagnosis |
Sets the maximum amount of time for finding errors to
report when an SQL script file is opened. The value must be an integer that
is greater than 0. When SQL script files are large, it can be helpful to limit
the time that is spent diagnosing errors. |
Default DB2 version |
Sets the DB2 version level at which syntax is parsed
when a script is opened in the Change Command Editor. |
Ignore semantic errors when reverse engineering |
Specifies that semantic errors will be ignored when
the models are created from SQL scripts. |
Ignore semantic errors when applying DDL to models |
Specifies that semantic errors will be ignored when
changing models with SQL scripts. If you choose to ignore errors, you can
later validate a model to find problems. |
Implicit objects used when reverse engineering |
When you create SQL scripts from models, specifies the
default values that will be used for the statements for implicitly created
objects. You can specify values for the partition group, the temporary partition
group, the buffer pool, and the table space. |
Forward engineering options |
Unchecking the Order the create statements
for derived objects option might leave create statements for derived
objects such as views, aliases and MQTs in the wrong order. If you uncheck
this option, remember to inspect the generated change commands to make sure
that each derived object is created before it is used by another derived object. |
Unload
provider |
Specifies the initial value of the Data Unload Provider
field on the Mapping Tables page of Generate Change Commands wizard.
Data will be unloaded for data preservation with this provider unless you
select a different provider on the wizard page. |
Load provider |
Specifies the initial value of the Data Load Provider
field on the Mapping Tables page of Generate Change Commands wizard.
Data will be loaded with this provider unless you select a different provider
on the wizard page. |