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

Document ID : KB000014699
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

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

Question:

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

 

Environment:
z/os db2
Answer:

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';