Drop an XA data source

Use the DROP XADATASOURCE statement to drop an XA data source.
DROP XADATASOURCE datasourcename RESTRICT;
For example: 
DROP XADATASOURCE informix.NewYork RESTRICT;

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

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

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

Parent topic: Create and drop XA data sources and data source types
Copyright© 2019 HCL Technologies Limited