stop dbaccess when a statement in a sql script fails

When using dbaccess to run a batch SQL script, how to instruct dbaccess to stop when a sql statement fails? For example, if mysqlscript.sql contains the following statement: BEGIN WORK; DELETE FROM mytable1 WHERE ......; INSERT INTO mytable2 VALUES (......);COMMIT WORK; If the delete fails the insert will still be executed and the transaction will be committed. Is there any way to let dbaccess stop when any of the statement fails? Regards, Carl Y. Wu