zOs/SQL/PDBGENKS

select *
    from rz2dd.tacct_general
    where corrname like 'CKS6007%'
    and timestamp > current timestamp - 40 days