Dropping an XA Data Source

Use 3the DROP XADATASOURCE statement to drop an XA data source type.

DROP XADATASOURCE datasourcename RESTRICT;

For example: 3

DROP XADATASOURCE informix.NewYork RESTRICT;

The XA data source type must already exist in the system because 3it was previously created with a CREATE XADATASOURCE TYPE statement. 3Information on the data source type is stored in the sysxasourcetypes system 3catalog table.

If an XA data source has been registered with a transaction that 3is not complete, the data source can be dropped only if the database 3is closed or the database session exits.

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