Ignore Trailing Spaces in Job Comparisons

Use the ignore_trailing_spaces new comparison option in the create job, replace job, and alter job commands for ignoring trailing spaces when comparing character datatypes. When the ignore_trailing_spaces is true, SAP DA considers “abc” and “abc ” values as equal.

Character datatypes include:

CHAR
NCHAR
VARCHAR
NVARCHAR
TEXT
NTEXT
CLOB
NCLOB

The space character is a Unicode value of 'space', U+0020.

Note: Trailing spaces are retained during reconciliation and reporting.

New Parameter:

ignore_trailing_spaces – Determines whether to ignore trailing spaces when comparing character datatype values.

Valid values are:

true – (default) ignores trailing spaces when comparing character datatype values.
false – does not ignore trailing spaces when comparing character datatype values.

For example, create a job named “person_job”:

create job person_job
add comparison person_cmpson
  set compareset=person_cmpset and
  set ignore_trailing_spaces=true
go

See Row Comparison Job Commands in the SAP Replication Server Data Assurance Option Users Guide.