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

2 New Features in SAP Replication Server

Data Assurance 15.7.1 SP202

SAP® Replication Server® Data Assurance Option 15.7.1 SP202 supports specifying the order of compareset

key columns in order by clauses, introduces a comparison option for ignoring trailing spaces in character

columns, allows you to direct job output to a directory of your choice, and introduces the with map option for

compareset commands.

2.1 Support for Sorting Key Columns in the Index Order

In SAP Replication Server Data Assurance Option (SAP DA) version 15.7.1 SP202, the create compareset

and alter compareset commands allow you to specify the order of compareset key columns in order by

clauses using an ordinal integer number in addition to a Boolean value.

Valid values for setting compareset key columns are:

● An integer value ranging from 1 to 2147483647 or 0 to indicate not a key column

● True or false

Note

SAP DA interprets true as 1 or greater, and false as zero (0).

Each key column must be a unique ordinal number within in the compareset. When a compareset has multiple

key columns, ordinal integer numbers are used to decide the order of the keys in the order by clause. The

order by clause is included in the select statement, which SAP DA issues to the source and target data

servers when selecting data to compare.

For example, when you compare an existing person table with these key columns:

create table person (

first_name varchar(50),

last_name varchar(50),

dob datetime,

primary key(last_name, first_name)

)

The primary keys places the last_name column ahead of the first_name column, and the data server is

optimized for sorting and retrieving rows in this order. A compareset can be created to select the rows in the

optimal order:

create compareset person

with source conn1 dbo person s

target conn2 dbo person t

map s.first_name = t.first_name set key = 2

and s.last_name = t.last_name set key = 1

and s.dob = t.dob

P U B L I C

New Features Guide

New Features in SAP Replication Server Data Assurance 15.7.1 SP202

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

Sin comentarios

Andersson HDB 1.0 Manual de usuario Pagina 20