Andersson HDB 1.0 Manual de usuario descargar pdf (Pagina 21)

When SAP DA selects rows from the “person” table for a comparison, this SQL query is generated:

select first_name,last_name,dob from dbo.person order by last_name,first_name

When you run the create compareset command with the map all parameter, SAP DA sets the compareset

key column ordinal numbers in the optimal order itself.

The pkey column is renamed to key and Y/N values are replaced with numbers in the show compareset

command output:

show compareset person columns

TYPE CONNECTION OWNER TABLE MAPID COLUMN KEY

---- ---------- ----- ------ ----- ---------- ----

S conn1 dbo person 1 first_name 2

T conn2 dbo person 1 first_name 2

S conn1 dbo person 2 last_name 1

T conn2 dbo person 2 last_name 1

S conn1 dbo person 3 dob

T conn2 dbo person 3 dob

See Compareset Commands in the SAP Replication Server Data Assurance Option Users Guide.

2.2 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 Features Guide

New Features in SAP Replication Server Data Assurance 15.7.1 SP202

P U B L I C

1 2 ... 16 17 18 19 20 21 22 23 24 25 26 ... 43 44

Sin comentarios

Andersson HDB 1.0 Manual de usuario Pagina 21