Create an XA data source

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

CREATE XADATASOURCE datasourcename USING datasourcetypename;

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

For example:

CREATE XADATASOURCE informix.NewYork USING informix.MQSeries;

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

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

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