zOs/SQL/TG002

select count(*) FROM OA1T.VTG003A1 ;
select count(*) FROM OA1T.VTG003A1
    WHERE TG_TRANSACTION_ID LIKE 'ACC3%' OR
          TG_TRANSACTION_ID LIKE 'MON3%' OR
          TG_TRANSACTION_ID LIKE 'SEC3%';
DELETE FROM OA1T.VTG003A1
WHERE TG_TRANSACTION_ID LIKE 'ACC3%' OR
      TG_TRANSACTION_ID LIKE 'MON3%' OR
      TG_TRANSACTION_ID LIKE 'SEC3%';
rollback;
;;;
-- DELETE FROM OA1T.VTG002A1
select count(*) FROM OA1T.VTG002A1 ;
select count(*) FROM OA1T.VTG002A1
WHERE TG_TRANSACTION_ID LIKE 'ACC3%' OR
      TG_TRANSACTION_ID LIKE 'MON3%' OR
      TG_TRANSACTION_ID LIKE 'SEC3%';