zOs/SQL/GBGRZ2R

delete from OA1P.TQZ008GBGRSCHWELLE
    where rz = 'RQ2' and prio >= 0;
insert into OA1P.TQZ008GBGRSCHWELLE  (PRIO, RZ, DBSYS, DB, TS, PART
      ,TSTY, DSMIN, SCHWELLE, VALIDBEGIN, VALIDEND
      , ERFASSER, grUse, grund)
select prio, 'RQ2', DBSYS, DB, TS, PART
      ,TSTY, DSMIN, SCHWELLE, VALIDBEGIN, VALIDEND
      , ERFASSER, grUse, grund
from OA1P.TQZ008GBGRSCHWELLE
    where rz = 'RZ2' and prio >= 0;
commit
;