Drop an XA data source type

You cannot drop an XA data source type until all of the XA data source instances that use the type are dropped.

To drop an XA data source type, use the DROP XADATASOURCE TYPE statement as follows: 
DROP XADATASOURCE TYPE datasourcetypename RESTRICT;
For example:
DROP XADATASOURCE TYPE informix.MQSeries RESTRICT;

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