zOs/JCL/GBGRCLEA

delete
    from oa1p.tqz008gbgrschwelle r
    where db like 'DEFAULT%' or db = 'index'
;
delete
    from oa1p.tqz008gbgrschwelle r
    where (rz <> '%' or dbSys <> '%')
    and exists ( select 1 from oa1p.tqz008gbgrschwelle a
           where a.rz = '%' and a.dbSys = '%'
                and a.db = r.db and a.ts = r.ts and a.part = r.part
                and a.tsty = r.tsTy
                and a.schwelle = r.schwelle
           )
;
select *
    from oa1p.tqz008gbgrschwelle r
    where db like 'DEFAULT%' or db = 'index'
;
select *
    from oa1p.tqz008gbgrschwelle r
    where (rz <> '%' or dbSys <> '%')
    and exists ( select 1 from oa1p.tqz008gbgrschwelle a
           where a.rz = '%' and a.dbSys = '%'
                and a.db = r.db and a.ts = r.ts and a.part = r.part
                and a.tsty = r.tsTy)