You can use the SET COMPOUND TRANSACTIONS statement:

    o  In interactive SQL

    o  In dynamic SQL as a statement to be dynamically executed