Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
DROP XADATASOURCE statementUse the DROP XADATASOURCE statement to drop a previously defined XA-compliant data source from the system catalog of the database.

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


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.