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

Products

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