DROP XADATASOURCE TYPE statement

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

This statement is an extension to the ANSI/ISO standard for SQL.

Syntax


1  DROP  XADATASOURCE TYPE? IF EXISTS  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 DROP XADATASOURCE TYPE statement is not supported on secondary servers within a high-availability cluster.

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.

If you include the optional IF EXISTS keywords, the database server takes no action (rather than sending an exception to the application) if no XA data source type of the specified name is registered in the current database.