Changing preferences for SQL scripts

You can change preferences for how DB2® Change Management Expert processes SQL scripts.
To change your preference settings for SQL scripts, complete the following steps:
  1. From the main menu, click Window > Preferences.
  2. In the Preferences window, expand Data and click Change Management Options.
  3. Change your preferences. The following table shows the preferences that you can change:
    Table 1. User preferences for SQL Scripts
    Item Description
    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.
    Start of changeDefault DB2 versionEnd of change Start of changeSets the DB2 version level at which syntax is parsed when a script is opened in the Change Command Editor.End of change
    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.
    Start of changeUnload providerEnd of change Start of changeSpecifies 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.End of change
    Start of changeLoad providerEnd of change Start of changeSpecifies 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.End of change


Feedback

Copyright IBM Corporation 2006, 2007. All Rights Reserved.