Skip to Main Content

GoldenGate

What is the use of KEYCOLS in Extract TABLE statements

User_XYoci6Jul 28 2022

I am editing some existing extract prm and see
TABLE NORTHDAT.CPOLEVAULTS, KEYCOLS (POLE_ID, STATE);
I understand for keycols in replicats, which tells replicats which columns to use for the where clause. What then is the purpose for extract? These columns need to be supplementally logged anyway so they will end up in the trail or automatically done if they are PKs. I want to remove this as it didn't seem to do anything. Any clues?

Comments
Post Details
Added on Jul 28 2022
0 comments
19 views