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.