Forum Stats

  • 3,854,903 Users
  • 2,264,431 Discussions
  • 7,905,826 Comments

Discussions

What is the use of KEYCOLS in Extract TABLE statements

User_XYoci6
User_XYoci6 Member Posts: 6 Red Ribbon

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?