>>-DROP--XADATASOURCE--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 |
Only Dynamic Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| xa_source | The XA-compliant data source to drop | Must be present in the sysxadatasources system catalog table | Identifier |
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 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.
Related statements: CREATE XADATASOURCE, CREATE XADATASOURCE TYPE, DROP XADATASOURCE TYPE
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.