Question about browsing HISTORY TABLES in RC/UPDATE R19 & R20

book

Article ID: 14699

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS

Issue/Introduction

Question about browsing HISTORY TABLES in RC/UPDATE R19 & R20



Is it possible to browse HISTORY TABLES in RC/UPDATE?

 

Environment

z/os db2

Resolution

If this is a Temporal History table then we do not browse it directly. 

You would get a message like this. 

RU694E Selected B option does not support HISTORY TABLES. 

 

You would need to do a Select against the table with a date range 

for the period of history you require. 

E.G 

SELECT CLIENT, PAY FROM POLICY_STT FOR SYSTEM_TIME FROM 

'2010-06-01-00.00.00.000000000000' TO '2017-06-01-08.00.00.000000000000' 

WHERE CLIENT='B';