User Exits
If you find that your application requires arithmetic calculation or data transformation beyond that provided by GoldenGate functions and SQLEXEC
, it is possible to invoke User Exits. These are user defined C or C++ function calls, extending the capabilities of GoldenGate. Typical applications for user exits are housekeeping tasks, data normalization, and conflict detection and handling.
Calling C routines
The user-defined functions may be called from either an Extract or Replicat process via the CUSEREXIT
parameter.
To use user exits, create a shared object in C and create a routine to be called from Extract or Replicat.
The routine must accept the following parameters that provide the communication between GoldenGate and your C program:
EXIT_CALL_TYPE
EXIT_CALL_RESULT
EXIT_PARAMS
The following is an example C function header for cleanup_task
, defining the required parameters:
void cleanup_task (exit_call_type_def exit_call_type, exit_result_def *exit_call_result, exit_params_def...