Home | Previous Page | Next Page   Database Access > Working with XA-Compliant External Data Sources > Managing XA Data Sources and Data Source Types > 3 3 3

Dropping an XA Data Source Type

3

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

3

To 3drop an XA data source type, use the DROP XADATASOURCE TYPE statement 3as follows:

3
DROP XADATASOURCE TYPE datasourcetypename RESTRICT;
3

For example: 3

3
DROP XADATASOURCE TYPE informix.MQSeries RESTRICT;
3

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

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]