ifx_removeDWA() function

The ifx_removeDWA() function removes (drops) an accelerator from the accelerator server. This function removes the connectivity information from the sqlhosts file in the Informix® database server. The data marts that are associated with the accelerator are not removed, but they are not accessible. Drop the data marts before you drop the accelerator.

Syntax


1  ifx_removeDWA ( ' accelerator_name ' )
accelerator_name
The name of the accelerator.

Usage

Important: To run the ifx_removeDWA() function, you must be logged in as user informix and you must have write access to the sqlhosts file and to the directory where the sqlhosts file is located.

You do not need a connection to the accelerator server to run the ifx_removeDWA() function.

Return value

The ifx_removeDWA() function returns the text string "The operation was completed successfully." or an error message.

Examples

This example shows how to drop an accelerator.

EXECUTE FUNCTION ifx_removeDWA('MyAccelerator');