Replication Processing

Replication processing lets you define advanced field-level transformations in addition to standard type-based conversion, using functions such as assignments, string and numeric operations, lookups, and decode logic. In the RDRS Dashboard, you configure these processing rules through a wizard accessed from the field replication connection, and enhanced processing is indicated by a special symbol on the connecting line.

In addition to the normal field type-based conversion of input data to output data, field contents can also be created or processed based on predefined functions:
  • Assignment of constants or dynamic values
  • Character string operations
  • Mathematical calculations
  • Boolean calculations
  • Lookup to other SQL tables to resolve key values
  • Invocation of exits to process field contents
  • Date conversion from and to numeric values
  • Decode functions
  • Automatic counters (for INSERTs)
  • Retrieval of contents of REXX variables
  • Combination of multiple functions from above
In the RDRS Dashboard, to define a processing definition, double-click on the connecting line for a field replication. The following dialog is displayed:
Properties of repository object
The defined processing rule is displayed in the internal short form. A single click on the function displays the wizard:
Properties

The example shows the wizard for the DECODE function. The current input field should be evaluated. If the field contains the character string "3", value "TE" becomes the output value; otherwise the value will be "PR".

A processing that goes beyond a standard field conversion is indicated by a special symbol displayed as part of the connecting line between input and output field.