Syntax options:

       SQLOPTIONS= (TRANSACTION_DEFAULT = IMPLICIT)
       SQLOPTIONS= (TRANSACTION_DEFAULT = DISTRIBUTED)
       SQLOPTIONS= (NOTRANSACTION_DEFAULT)

    Specifies when SQL starts a transaction and how SQL handles
    default distributed transactions. You can specify the following
    options:

    o  SQLOPTIONS = (TRANSACTION_DEFAULT = IMPLICIT)

       Causes SQL to start a transaction when you issue either a SET
       TRANSACTION statement or the first executable SQL statement in
       a session.

    o  SQLOPTIONS = (TRANSACTION_DEFAULT = DISTRIBUTED)

       Causes SQL to use the distributed transaction identifier
       (TID) for the default distributed transaction established
       by the DECdtm system service SYS$START_TRANS. Using this
       option eliminates the need to declare context structures in
       SQL precompiled programs and to use the USING CONTEXT clause
       in embedded SQL statements. Because it closes all cursors,
       it also eliminates the need to call the SQL_CLOSE_CURSORS
       routine.

       You must explicitly call the DECdtm system services when you
       use this option.

       This option provides support for the Structured Transaction
       Definition Language (STDL) of the Multivendor Integration
       Architecture (MIA) standard.

       If you specify the USING CONTEXT clause in embedded SQL
       statements, you must declare a context structure.

    o  SQLOPTIONS=(NOTRANSACTION_DEFAULT)

       Causes SQL not to start a transaction unless you execute a SET
       TRANSACTION statement. If you use this qualifier and issue an
       executable statement without first issuing a SET TRANSACTION
       statement, SQL returns an error.

    The default is SQLOPTIONS = (TRANSACTION_DEFAULT = IMPLICIT).