Update Before

The Update Before events provide you with the before image of records updated in a table on the source system. Depending on the type of Update Before event that has taken place on the source system, CDC Replication generates a journal code.

The following list describes the IBM® i journal codes for Update Before events:

UB

Indicates the before image of a record updated in a table on the source system.

FD

Indicates the before image of a record updated in a table on the source system that satisfies a row selection expression. CDC Replication appends this entry to the audit table on the target system as a Filtered Record Delete. FD is a journal code generated by CDC Replication. It is not an IBM i journal code.

FB

Indicates the before image of a record updated in a table on the source system that does not satisfy a row selection expression. CDC Replication appends this entry to the audit table on the target system as a Filtered Record Insert. This record is only placed in the audit table when the corresponding after image satisfies the row selection expression (FI) and you want to include both images in the audit table. Otherwise, CDC Replication only includes a single record (FI) in the audit table. You can audit both images using an CDC Replication system parameter. For more information, see the appropriate CDC Replication User Manual for your platform. FB is a journal code generated by CDC Replication. It is not an IBM i journal code.

BR

Indicates the before image of a record updated for rollback in a table on the source system.