PowerExchange Functions for User-Defined Fields Overview
PowerExchange Functions for User-Defined Fields Overview
In data maps, you can define fields in records that use one or more PowerExchange functions in an expression to process source data.
These functions provide operations such as field splitting and concatenation. You can also use the CallProg function in an expression to invoke a user-defined program to process source data.
PowerExchange provides example user-defined programs with headers files and JCL. These files, named
ucpe*.*
, are located in the examples directory in the PowerExchange Navigator installation directory. Edit and compile these example programs to customize them for your environment.
After you define a user-defined field, run a database row test to test any PowerExchange and user-defined functions defined for the field.
If you plan to generate before-image and change-indicator columns for user-defined fields, ensure that the functions associated with the fields support before-image buffering. If the functions do not support before-image buffering, the before-image and change-indicator are not generated.