ifx_grid_disconnect() procedure

The ifx_grid_disconnect() procedure closes a connection to the grid.

Syntax


1  EXECUTE PROCEDURE ifx_grid_disconnect ( ) ;

Usage

Use the ifx_grid_disconnect() procedure to disable the propagation of DDL statements and commands to servers in the grid, which was enabled by the ifx_grid_connect() procedure. If you do not use the ifx_grid_disconnect() procedure, propagation through the grid is stopped when the database is closed or the connection is closed.

You must run this routine as an authorized user on an authorized grid server, as specified by the cdr grid enable command.

Example

The following example shows how to close a connection to the grid after opening a connection:

EXECUTE PROCEDURE ifx_grid_connect('grid1');
EXECUTE PROCEDURE ifx_grid_disconnect();