DROP XADATASOURCE TYPE

Use the DROP XADATASOURCE TYPE statement to drop a previously defined XA-compliant data source type from the database.

Only Dynamic Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.

Syntax

>>-DROP--XADATASOURCE TYPE--xa_type--RESTRICT------------------><

Element	Description	Restrictions	Syntax
xa_type	Name of the XA data source type to be dropped	Must be present in the sysxasourcetypes system catalog table	Identifier

Usage

The RESTRICT keyword is required. You cannot unregister an XA data source type if virtual tables or indexes exist that use the data source. You must be user informix or have DBA privileges to drop an XA data source type.

The following statement drops an XA data source type called MQSeries owned by user informix:

        DROP XADATASOURCE TYPE informix.MQSeries RESTRICT;

You cannot drop an XA data source type until after all the XA data source instances that use that data source type have been dropped.

Related Information

For a description of the RESTRICT keyword, see Specifying RESTRICT Mode. For information on how to use XA data sources, see the IBM Informix DataBlade API Programmer's Guide.