XAID

Simplifies working with multiple XARs of the SQL Server, PostgreSQL, or generic one-phase commit for ODBC RM types defined in a single enterprise server region.

Syntax:

XAID=xarid

Parameters:

xarid
The XAR ID set in the enterprise server region XAR definition.

Properties:

Default: None

Scope:

Used at compile time: Yes
Behavior at run time: Source file

See Scope - OpenESQL SQL Compiler Directive Options for more information.

Comments:

XAID has the same effect as inserting an EXEC SQL SET CONNECTION statement before every EXEC SQL statement in a program.

XAID is mandatory when using more than one XAR defined with the same RM switch module type for use in, for example, online CICS or Web Services applications.

XAID is also mandatory when a MFDBFH XAR and a distinct embedded SQL XAR are both accessing SQL Server or PostgreSQL for use in any online application.