GG Informix Extract Captures Primary Key(GGSPKUPDATE) update as a FieldComp (Doc ID 2039248.1)

Last updated on AUGUST 03, 2015

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 to 12.1.3.0.0 [Release 12.1]
Information in this document applies to any platform.

Goal

GG for Informix extract writes Primary Key Update records as FieldComp(Update)

This is due to the fact that set clause specify serial data type.

Tables have many serial data type.
Therefore, if update query executes with row migration on Oracle database, replicat for Informix will be abend.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms