RMXA - define a name for an XA database connection (Unix, Linux and Windows systems)

The XA interface standardized by X/Open allows you to link openUTM to any Resource Manager that supports this interface, e.g. the database system Oracle. openUTM supports this connection via the XA CAE interface (CAE specification).

A separate RMXA statement must be issued for each Resource Manager instance.

The start parameters for the Resource Manager generally determine the database to which openUTM is linked via the Resource Manager.

RMXA	XASWITCH=name  [ ,USERID=username | C‘username‘ ]  [ ,PASSWORD=C'password' ]  [ ,DLLIMPORT={ YES | NO } ]  [ ,XA-INST[-NAME]=inst-name ]

XASWITCH=	name Name of the xa_switch_t structure of the Resource Manager, which is made known to openUTM. The value entered for name is predefined in the respective Resource Manager. The name my be up to 54 characters in length. Further information can be found in section "Defining database linking".) This is a mandatory operand.
USERID=	username | C‘username‘ If a user name is to be passed to the database system in lowercase characters, then you must use the format C'username'. Alternatively, the user name can be transferred to the database system by means of start parameters. It is possible to modify the user name and/or the password by means of dynamic administration.
PASSWORD =	C'password' Specifies a password for the database system. The password can be up to 30 characters in length. openUTM passes the password to the database system if the placeholder *UTMPASS has been specified for the password in the Open string. In other words openUTM replaces '*UTMPASS' in the start parameter by the value generated here. Alternatively, the password can be transferred to the database system by means of start parameters.
DLLIMPORT=	Specifies how the xa_switch_t structure of the Resource Manager is to be addressed.
YES	Only permitted in openUTM on Windows systems. The xa_switch_t structure is addressed with dllimport. You must generate DLLIMPORT=YES to connect to Oracle on Windows systems.
NO	The xa_switch_t structure is addressed using extern. Default: NO
XA-INST-NAME=	This parameter is permitted only if TYPE=XA was specified. inst-name is the local name for the XA instance which is 1 to 4 characters long. If more than one RMXA statement is generated for an application, the XA-INST-NAME values in the applications must differ. The parameter can be omitted for applications with just one RMXA statement. The string specified for XA-INST-NAME must be specified after the string ".RMXA" in the prefix for the start parameters for this database. Example: Specification in the RMXA statement: RMXA....,XA-INST-NAME=DB1 Specification in the start parameters for this data base: .RMXADB1 RM="rm-name",OS="open-string",... Default: blanks