Setting Schema Management options
You can set the behavior for the Schema Management feature by clicking Options 
. These settings also serve as the default option settings for all new Schema Compare views.
Related topics
You can specify the following options:
Option | Description | Default value |
|---|---|---|
Use European format for decimal numbers (EURO) | Select whether to use the European decimal format (1.234.567,89). This value corresponds to the Change Manager EURO installation option. | No |
Use padded values for columns of type VARCHAR (PADDED) | Select whether to pad VARCHAR values. This option corresponds to the Change Manager OVERRIDE( IXPADDEDY ) and OVERRIDE( IXPADDEDN ) ALUIN keywords, and to the PADIX DSNZPARM. | No |
Include the primary key constraint in the scope (UCPKPALL) | Select whether to include the primary key constraint in the scope. This option corresponds to the Change Manager OVERRIDE( KEEP-ALL-PRIMARY ) ALUIN keyword. | No |
Include white spaces in native SQL stored procedure comparisons (CMPSPTXT) | Select whether to include white spaces in native SQL stored procedures. This option corresponds to the Change Manager CMPSPTXT installation option and the SPTEXT( EXACT ) or SPTEXT( NOEXACT ) ALUIN keyword. | Yes |
Generate an ALTER TABLE RENAME COLUMN statement when the only difference between two table definitions is a column rename (RENAMECOL) | Select whether to generate a column rename statement or drop-and-add statements when the only difference between two table definitions is a column rename. If you select this option, Change Manager generates column rename statements. This option corresponds to the Change Manager RENAMECOL installation option and the RENAMECOL or NORENAMECOL ALUIN keywords. | No |
CCSID | Select the default encoding scheme for databases that are created. This option corresponds to the Change Manager CCSID installation option. | EBCDIC |
CISIZE | Select N to create VSAM data sets with a control interval size (CISIZE) of 4 KB, regardless of the page size (buffer pool size) of the table space. Select Y to support larger CISIZE values. This option corresponds to the DSVCI DSNZPARM. | Blank |
Length of inline LOB columns | Enter a value for the inline LOB column. This option corresponds to the LOB_INLINE_LENGTH DSNZPARM. | 0 |
OVERRIDE | Enter one or more space-separated Change Manager OVERRIDE keywords (maximum of 57 characters). For more information, see OVERRIDE-keywords. | NA |