ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
RCU/RCM: Strategy using IBM Load shows column DSN_RCTIMESTAMP which is not a table column why?
Article ID: 141826
RC Compare for DB2 for z/OSDatabase Management for DB2 for z/OS - Administration SuiteEndevor SCM Interface for DB2 for z/OSEndevor SCM Interface for Remote DB2 for z/OSRC/Extract for DB2 for z/OSRC/Migrator for DB2 for z/OSRC/Merger for DB2 for z/OSRC/Query for DB2 for z/OSRC/Secure for DB2 for z/OSRC/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).