RCU/RCM: Strategy using IBM Load shows column DSN_RCTIMESTAMP which is not a table column why?
Article ID: 141826
CA RC Compare for DB2 for z/OSCA Database Management for DB2 for z/OS - Administration SuiteCA Endevor SCM Interface for DB2 for z/OSCA Endevor SCM Interface for Remote DB2 for z/OSCA RC/Extract for DB2 for z/OSCA RC/Migrator for DB2 for z/OSCA RC/Merger for DB2 for z/OSCA RC/Query for DB2 for z/OSCA RC/Secure for DB2 for z/OSCA RC/Update for DB2 for z/OS
When a strategy is using an IBM Unload/IBM Load for utility options, and the strategy contains a Temporal Table, the IBM Load control statements may contain columns that are not on the table.
The strategy will generate the necessary columns, as required by IBM LOAD when loading a Temporal table.
Release : 20.0
Component : RC/Update, RC/Migrator
These column names in the load control cards (i.e DSN_RCTIMESTAMP), are described in the IBM Load chapter of the DB2 utility guide. There are special names for all the system time temporal table specific columns (4 DIFFERENT ONES).