zOs/TX/TATSEL

set current application compatibility 'V11R1';
select SYSIBMADM.get_ARCHIVE from sysibm.sysDummy1;
select i1, left(c2, 40)
    from qz92CrT.tqz91TatA
    where i1 <= 007
    order by i1 desc
    fetch first 20 rows only
;
select i1, left(c2, 40)
    from qz92CrT.tqz91TatH
    where i1 <=  007
    order by i1 desc
    fetch first 20 rows only
;
select SYSIBMADM.get_ARCHIVE from sysibm.sysDummy1;
set  SYSIBMADM.get_ARCHIVE = 'Y';
select SYSIBMADM.get_ARCHIVE from sysibm.sysDummy1;
select SYSIBMADM.get_ARCHIVE from sysibm.sysDummy1;
select current temporal system_time from sysibm.sysDummy1;
set current temporal system_time '2016-04-15-12.55.11.168313';
select current temporal system_time from sysibm.sysDummy1;
select i1, left(c2, 40)
    from qz92CrT.tqz91TatA
     -- for system_time as of '2016-04-15-12.55.11.168313'
    where i1 =  007
    order by i1 desc
    fetch first 20 rows only
;
select i1, left(c2, 40)
    from qz92CrT.tqz91TatH
    where i1 =  007
    order by i1 desc
    fetch first 20 rows only
;