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



Was this page helpful? Yes No Submitting... Thank you

Comments