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

Supported Datatype Conversion Description

DATE to VARCHAR SRS converts date values into date strings such as “Oct 20 1972”. This is

not the DA default DATE pattern. You must use the following

java.text.SimpleDateFormat pattern in the FORMAT_DATE

comparison or column FORMAT options:

MMM d yyyy

TIME to VARCHAR SRS converts time values into time strings such as “01:05:51:976PM”.

This is not the DA default TIME pattern. You must use the following

java.text.SimpleDateFormat pattern in the FORMAT_TIME

comparison or FORMAT column options:

hh:mm:ss:SSSaa

DATETIME to VARCHAR SRS converts datetime values into datetime strings such as “Oct 20 1972

01:05:51:976PM”. This is not the DA default TIMESTAMP pattern. You

must use the following

java.text.SimpleDateFormat pattern in

the comparison FORMAT_TIMESTAMP or column FORMAT options:

MMM d yyyy hh:mm:ss:SSSaa

1.1.2 Column Options

SAP Replication Server Data Assurance Option (SAP DA) version 15.7.1 SP204 introduces four new optional

column options.

The new options override comparison options with the same (or similar) names. These options can also be

used to infer additional type information to the agent hash and external sort.

Unlike all other configurations, these options are not required to be set and have no defaults.

Table 3: Optional Column Options in DA

Name

Description

FORMAT Overrides a Comparison format. If not set, the Comparison formats are used

as required.

Valid values: Any valid FORMAT_BYTES, FORMAT_DATE, FORMAT_TIME or

FORMAT_TIMESTAMP value

Default: N/A

IGNORE_TRAILING_SPACES 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

New Features Guide

New Features in SAP Replication Server Data Assurance 15.7.1 SP204

P U B L I C

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

Sin comentarios

Andersson HDB 1.0 Manual de usuario Pagina 7