Creating an XA Data Source

To 3create an XA data source, use the CREATE XADATASOURCE statement, 3as follows:

CREATE XADATASOURCE datasourcename USING datasourcetypename;

The datasourcename and datasourcetypename optionally 3include the owner name separated from the data source type name 3by a period.

For example: 3

CREATE XADATASOURCE informix.NewYork USING informix.MQSeries;

ANSI database and non-ANSI database namespace rules apply for 3the XA data source type, XA data source names, and user-defined 3function names.

Each new XA data source will have a unique ID in the sysxadatasources system catalog 3table.

For syntax details, see the IBM Informix: Guide to SQL Syntax.