A user exit lets you define a set of actions that IBM InfoSphere CDC can run before or after a database event occurs on a specified table. When using IBM InfoSphere CDC, a database event is defined as either a row-level operation or as a table-level operation. Row-level operations include an insert, update, or a delete. Table-level operations include a refresh or a truncate operation. For example, you can configure a row-level user exit program that sends an alert after IBM InfoSphere CDC replicates a delete operation on a particular target table.
User exits can be grouped as either a Before User Exit or an After User Exit:
▪Before User Exit: Runs before IBM InfoSphere CDC replicates any row-level or table-level operations to the target table.
▪After User Exit: Runs after IBM InfoSphere CDC replicates any row-level or table-level operations to the target table.
The following list identifies common scenarios for developing a user exit program before or after row or table-level operations:
▪Customize when IBM InfoSphere CDC replicates a row-level operation to the target table. For example, you can develop logic for insert, update, or delete operations so that these occur based on some specified criteria, such as the original invoice date. IBM InfoSphere CDC can run the user exit and apply the row-level operation (insert, update, or delete) to the appropriate target table based on the original invoice date, such as, January 2004, February 2004, November 2006, and so on.
▪Disable the default row-level or table-level operations, and replace them by invoking a user exit program that performs custom operations. For example, in response to a table-level truncate operation, you can develop a user exit that lets you do a soft delete rather than a hard delete on the target table.