Setting Schema Management options
You can use the Options button (in the New console, click ) to set optional behavior for the Schema Management feature. These settings also serve as the default option settings for all new Schema Compare views.
Note
You can override the options settings for a specific Schema Compare View in the Define a Comparison wizard. For more information, see Comparing two schemas.
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 | 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 | 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 |
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). Note Do not enclose the OVERRIDE keywords between parentheses. For more information, see OVERRIDE keywords. | NA |
Enable Trace (Available in the Classic console only) | Select whether to include informational messages. Consult with BMC Customer Support before using this option. | No |
Comments
Log in or register to comment.