rs_subcmp configuration parameters

Table 2-4 lists the rs_subcmp new command-line parameters.

Table 2-4: rs_subcmp new command line parameters

Parameter

Description

-g

Data reconciliation script flag that creates data reconciliation script.

-h

Instructs rs_subcmp to perform faster comparison.

-H

Instructs rs_subcmp to normalize the data when using hash algorithm for cross platform or different character sets situation.

-I

Specifies the name and location of the interfaces file to search.

-x

A comparison flag. 0 (default) – data comparison 1 – database schema comparison 2 – table schema comparison

-X

A filter flag. If the value starts with “+” only the schema types are selected for comparison, and the sub-types are ignored. Otherwise, the schema types and subtypes are both unselected and used for comparison.

Table 2-5 lists the rs_subcmp new configuration file parameters.

Table 2-5: rs_subcmp new configuration file parameters

Parameter

Description

SCHEMAFLAG

Comparison flag 0 (default) – data comparison 1 – database schema comparison 2 – table schema comparison

FILTER

Filter flag If the value starts with “+” only the schema types are selected for comparison, and the sub-types are ignored. Otherwise, the schema types and sub-schema types are both deselected and will not be used for comparison.

IFILE

Specifies the name and location of the interfaces file to search.

RECONCILE_FILE

Data reconciliation script flag Y – creates data reconciliation script N (default) – do not create data reconciliation script

FASTCMP

Identical to command line parameter -h. The syntax is: FASTCMP = Y|N Values are: Y – Do fast comparison using compressed data N (default) – Do normal comparison as before

HASH_OPTION

Indentical to command line parameter -H. The syntax is: HASH_OPTION = lsb | msb | unicode | unicode_lsb | unicode_msb If this parameter does not exist in the configuration file, by default, rs_subcmp will use the native byte order and character set.