Teradata does it have a ROLLBACK -

begin transaction;      delete dw_rx_v.rx_fll_fct     rx_nbr  = in_rx_nbr        , rx_fll_dte  = cast(in_rx_fll_dte timestamp(6) format 'mmddyyyy')       , rfl_tie_brk_nbr   = in_rfl_tie_bkr;      if :activity_count = 0         rollback;     signal error_handler;      end if;       delete dw_rx_v.rx_fll_det     rx_nbr = in_rx_nbr        , rx_fll_dte  = cast(in_rx_fll_dte timestamp(6) format 'mmddyyyy')       , rfl_tie_brk_nbr   = in_rfl_tie_bkr;      if :activity_count = 0         rollback;     signal error_handler;      end if;  end transaction; 

i tried using stored procedure block above, upon running, still not able rollback transaction upon failure.

does teradata have rollback?

so want is, everytime there no record found on second dml statement, rollback deleted start.