You can subdivide a transaction into self-contained units (subtransactions).
See also:
SQL Reference Manual, SUBTRANS Statement (subtrans_statement)