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

Name Description

SCALE Specifies the maximum number of scale digits (digits to the right of the deci

mal point) in a number that is compared. If a number's scale is greater than

the SCALE option value, its scale is rounded up to match the number of digits

in the SCALE value. For example, when the SCALE value is 3, DA rounds

1.0017 up to 1.002. If you want:

● 1.002 to equal 1.0017, set the scale rounding to 3 or lower.

● -467.84921 to equal -467.849207, set the scale rounding to 5 or lower.

● 98.1 to equal 98.2, set the scale rounding to 0

Any negative value disables this option and DA compares all numbers as is.

Valid values: -2147483648 to 2147483647

Default: 10

1.1.1.1 Date, Time and Timestamp Formats

The date, time and timestamp parsing and formatting are performed by the

java.text.SimpleDateFormat class.

For more information about date and time formats, see the Java API documentation.

1.1.1.2 Supported SAP Replication Server (SRS) Column

Level Translations

SAP Replication Server (SRS) supports numerous column-level translations.

The DA comparison options FORMAT_DATE, FORMAT_TIME and FORMAT_TIMESTAMP (and the column

option FORMAT) enable DA to support SAP Replication Server (SRS) environments when SRS column-level

translations are happening. Column-level translations happen when primary table column values are changed

into a different datatypes as they are replicated.

Table 2: Datatype Conversion at Column Level

Supported Datatype Conversion

Description

INT to VARBINARY SRS converts 1234 into 0xD204. By default, DA converts VARBINARY val

ues into INT values by reversing this RS conversion.

REAL to VARCHAR SRS converts 123.456 into “123.456”. By default, DA converts VARCHAR

values into REAL values by reversing this SRS conversion (this is per

formed automatically in DA).

VARBINARY to VARCHAR SRS converts 0x616263 into “616263”. By default, DA converts VARBI

NARY values into VARCHAR values by reversing this SRS conversion.

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 ... 43 44

Sin comentarios

Andersson HDB 1.0 Manual de usuario Pagina 6