ANSI/ISO SQL does not provide a save transaction or begin transaction statement. Instead, transactions begin implicitly when the application program executes one of the following statements:
delete
insert
select
update
open
exec
The transaction ends explicitly when you issue either a commit work or rollback work statement. You must use the ANSI/ISO forms of the commit and rollback statements.
The syntax is:
exec sql commit [work] end-exec
exec sql rollback [work] end-exec
