CREATE OR REPLACE TABLE PHP_DAVE1.DEPT
      (DEPTNO    CHAR(3)       NOT NULL,
       DEPTNAME  VARCHAR(36)   NOT NULL,
       MGRNO     CHAR(6),
       ADMRDEPT  CHAR(3)       NOT NULL,
       LOCATION  CHAR(16),
       START_TS  TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS ROW BEGIN,
       END_TS    TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS ROW END,
       TS_ID     TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS TRANSACTION START ID,
      PERIOD SYSTEM_TIME (START_TS, END_TS),
      PRIMARY KEY (DEPTNO));
CREATE TABLE PHP_DAVE1.DEPTHIST LIKE PHP_DAVE1.DEPT;
ALTER TABLE PHP_DAVE1.DEPT ADD VERSIONING USE HISTORY TABLE PHP_DAVE1.DEPTHIST;
INSERT INTO PHP_DAVE1.DEPT (DEPTNO, DEPTNAME, MGRNO, ADMRDEPT, LOCATION) VALUES ('2', 'Call Center Dept', '2', '2', '2');

--Must have a journal on the temporal table
Call qcmdexc('CRTJRNRCV JRNRCV(PHP_DAVE1/DEPTJR) ASP(1) THRESHOLD(100000) AUT(*ALL) TEXT(''Test'')');
Call qcmdexc('CRTJRN   JRN(PHP_DAVE1/DEPTJ)  JRNRCV(PHP_DAVE1/DEPTJR)  ASP(1)');
Call qcmdexc('STRJRNPF FILE(PHP_DAVE1/DEPT) JRN(PHP_DAVE1/DEPTJ) IMAGES(*BOTH)');
Call qcmdexc('CRTJRNRCV JRNRCV(PHP_DAVE1/DEPTHISTJR) ASP(1) THRESHOLD(100000) AUT(*ALL) TEXT(''Test'')');
Call qcmdexc('CRTJRN   JRN(PHP_DAVE1/DEPTHISTJ)  JRNRCV(PHP_DAVE1/DEPTHISTJR)  ASP(1)');
Call qcmdexc('STRJRNPF FILE(PHP_DAVE1/DEPTHIST) JRN(PHP_DAVE1/DEPTHISTJ) IMAGES(*BOTH)');

UPDATE PHP_DAVE1.DEPT SET DEPTNAME='Customer Service' WHERE DEPTNO=2;
SELECT * FROM PHP_DAVE1.DEPT;
SELECT * FROM PHP_DAVE1.DEPTHIST;
-- SELECT * FROM PHP_DAVE1.DEPT FOR SYSTEM_TIME AS OF CURRENT TIMESTAMP - 4 minutes;