Andersson HDB 1.0 Bedienungsanleitung PDF herunterladen (Seite 8)

Name Description

IGNORE_ZERO_PADDING Overrides the Comparison option with the same name. If not set, the Compar

ison option is used as required.

Valid values: true or false

Default: N/A

SCALE Overrides the Comparison option with the same name. If not set, the Compar

ison option is used as required.

Valid values: -2147483648 to 2147483647

Default: N/A.

1.1.2.1 Examples

Replication Server supports column-level translations, which can change column value data types as they are

replicated.

For example, DATE data types in the primary table might be inserted into the replicate as VARCHAR (date

strings).

Review the sample code that shows how Data Assurance(DA) can compare DATE to VARCHAR using the

Column FORMAT option.

The primary (source) table is defined as:

create table tab (id int, a_date date)

The replicate (target) table is defined as:

create table tab (id int, a_varchar varchar(50))

Replication Server is configured to translate DATE values thus:

{2014-02-14} -> ‘2014 Feb 14’

Assuming the appropriate DA connections have already been configured, the DA compareset, comparison and

job objects can be configured thus:

create compareset cs1

with source conn1 dbo tab s

target conn2 dbo tab t

map s.id = t.id set key=1

and s.a_date = t.a_varchar

create job job1

add comparison cmpson1

set compareset cs1

with column option

set a_date “compare_mode literal, format ‘yyyy MMM dd’”

P U B L I C

New Features Guide

New Features in SAP Replication Server Data Assurance 15.7.1 SP204

1 2 3 4 5 6 7 8 9 10 11 12 13 ... 43 44

Keine Kommentare

Andersson HDB 1.0 Bedienungsanleitung Seite 8