You can use a UOC routine to edit and process update information before importing it.

The following figure shows an example of using a UOC routine to edit update information at the target, and then importing it.

Figure 4-13 Example of using a UOC routine to edit update information at the target, and then importing it

Explanation

• Name of UOC routine used to edit update information
  To use a UOC routine to edit update information before importing it, specify the name of the UOC routine in the by clause of the import table definition.
  
• UOC routine's processing
  The field data in the update information specified in the load statement of the import table definition is passed to the UOC routine. The UOC routine must process the received data, and then create and issue an SQL statement to execute import processing.
  Use the functions provided by the target Datareplicator to create the UOC routine, and then compile and link it.
  
• Sample UOC routines
  The target Datareplicator provides sample UOC routines. You can use these routines to create your own UOC routines.