CREATE XADATASOURCE

3>>-CREATE XADATASOURCE--xa_source--USING--xa_type--------------><
3

3 3 333333333333333333333333

Element	Description	Restrictions	Syntax
xa_source	Name that you declare here for the new XA data source	Must be unique among XA data source names in sysxadatasources	Database Object Name, p. Database Object Name
xa_type	Name of an existing XA data source type	Must already exist in the database in the sysxasourcetypes system catalog table	Database Object Name, p. Database Object Name

Usage

An XA-compliant data 3source is an external data source that complies with the X/Open DTP XA Standard 3for managing interactions between a transaction manager and a resource manager. 3To register XA-compliant data sources in the database requires two SQL statements:

First create one or more XA-compliant data source types by using the CREATE 3XADATASOURCE TYPE statement.

Then create one or more instances of XA-compliant data sources with the 3CREATE XADATASOURCE statement.

You can integrate transactions at the XA data source with the Dynamic 3Server transaction, using a 2-phase commit protocol to ensure that transactions 3are uniformly committed or rolled back among multiple database servers, and 3manage multiple external XA data sources within the same global transaction.

Any 3user can create an XA data source, which follows standard owner-naming rules, 3according to the ANSI-compliance status of the database. Only a database that 3uses transaction logging can support the X/Open DTP XA Standard.

Both XA data source types and instances of XA data sources are specific 3to one database. To support distributed transactions, they must be created 3in each database that interacts with the external XA data source.

The following statement creates a new XA data source instance called informix.NewYork of type informix.MQSeries.

CREATE XADATASOURCE informix.NewYork USING informix.MQSeries;

Related Information

For the schema of the sysxadatasources system catalog 3table, see the documentation notes to the IBM Informix Guide to SQL: Reference. 3For more information on XA data sources, see the IBM Informix DataBlade API Programmer's Guide.