DROP XADATASOURCE statement

Use the DROP XADATASOURCE statement to drop a previously defined XA-compliant data source from the system catalog of the database.

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

Syntax


1  DROP  XADATASOURCE? IF EXISTS  xa_source  RESTRICT
Element Description Restrictions Syntax
xa_source The XA-compliant data source to drop Must be present in the sysxadatasources system catalog table Identifier

Usage

The RESTRICT keyword is required. You must be the owner of the XA data source or hold DBA privileges to drop an access method.

The DROP XADATASOURCE statement is not supported on secondary servers within a high-availability cluster.

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 of the specified name is registered in the current database.

The following statement drops the XA data source instance called NewYork that is owned by user informix. 
DROP XADATASOURCE informix.NewYork RESTRICT;

You cannot drop an access method if it is being used in a transaction that is currently open. If an XA data source has been registered with a transaction that is not complete, you can drop the data source only after the database is closed or the session ends.