Code: Select all
, ITABLE4 AS
( SELECT ' '
CONCAT
X'7D' CONCAT
CHAR ( CURRENT_TIMESTAMP - 30 DAYS
) CONCAT
X'7D' AS WHENCLAUSE
, '04' AS SORTSEQ
FROM SYSIBM.SYSDUMMY1
FETCH FIRST 1 ROW ONLY
)
Code: Select all
, ITABLE4 AS
( SELECT ' '
CONCAT
X'7D' CONCAT
CHAR ( LAST_EXTRACT_TS
) CONCAT
X'7D' AS WHENCLAUSE
, '04' AS SORTSEQ
FROM DCSUD1.EXTRACT_CONTROL
WHERE TABLE_NAME = 'DCSXXXX'
AND RECORD_STATUS = 'A'
FETCH FIRST 1 ROW ONLY
)