Previous Topic Next topic Print topic


SQL xa_open string Configuration Option

Describes Micro Focus-specific xa_open string option available for defining XARs.

Visual COBOL provides an xa_open string option for XARs in addition to those provided by each database vendor.

You can add this option to a resource definition by including it in the xa_open string using the format specified by the database vendor. For example, most databases use a comma separator (,), but Oracle uses a plus sign (+) separator. See your database documentation for more information.

LocalTX={T|F}
Determines how the XAR handles transactions.
T
The associated XAR uses local (non-distributed) transactions. This option reduces overhead, and therefore can be a good option when using a single XAR. Be advised, however, that LocalTX=T also handles commits and roll backs for each XAR, independent of other resources, and should be used with care.
F
The associated XAR uses XA distributed, global transactions. Default.
Previous Topic Next topic Print topic