zOs/SQL/REOTSIX

select *
    from s100447.tReoRunJob t
    where job = 'QR38704S'
        and tst > '2010-11-28-11.00.00'
;;
with ti as
(
select t.*,
               (select min(n.tst)
                    from s100447.tReoRunJob n
                    where t.job = n.job
                        and t.tst < n.tst
                        and t.eoj + 1 hour > n.tst
                        and n.tyInp = 'IX'
               ) ixTst
    from s100447.tReoRunJob t
    where t.tyInp = 'TS' and t.tst > current timestamp - 7 days
)
select * from ti where ixTst is null