SELECT A.TIMESTAMP, T.TIMESTAMP 00001006
FROM SYSIBM.SYSCOPY A, 00002005
CHSKA000DBTF.SYSIBM.SYSCOPY T 00003005
WHERE A.TIMESTAMP = T.TIMESTAMP AND 00004003
A.TIMESTAMP > CURRENT TIMESTAMP - 1 HOURS 00005007
; 00006003
ENDE 00007003
INSERT 00010000
INTO REVI.DB2LOAD 00020000
( 00030000
"GROUP", 00040000
TIMESTAMP, 00050000
DBNAME, 00060000
TSNAME, 00070000
DSNUM, 00080000
ICTYPE, 00090000
JOBNAME, 00100000
AUTHID 00110000
) 00120000
SELECT 00130000
'DBTF', 00140000
TIMESTAMP, 00150000
DBNAME, 00160000
TSNAME, 00170000
DSNUM, 00180000
ICTYPE, 00190000
JOBNAME, 00200000
AUTHID 00210000
00220000
FROM CHSKA000DBTF.SYSIBM.SYSCOPY 00230001
WHERE TIMESTAMP > CURRENT TIMESTAMP - 5 DAYS + 3 HOURS 00240002
; ( 00250002
SELECT MAX(TIMESTAMP) 00260000
FROM REVI.DB2LOAD 00270000
WHERE GROUP = 'DBTF' 00280001
) 00290000
AND TIMESTAMP <= CURRENT TIMESTAMP - 5 DAYS + 3 HOURS 00300000
; 00310000
00320000
COMMIT ; 00330000
00340000