ifx_grid_procedure() procedure

The ifx_grid_procedure() procedure propagates the execution of a procedure to all servers in the grid.

Syntax


1  EXECUTE PROCEDURE ifx_grid_procedure (  ' grid_name '  , ' procedure_text '?  , ' tag '  ) ;
Element Purpose Restrictions Syntax
grid_name Name of the grid. Must be the name of an existing grid.
procedure_text The text format of the procedure to be run. Bound data items cannot be included.
tag A character string to identify grid operations.

Usage

Use the ifx_grid_procedure() procedure to run a procedure or SQL statement on a source server and propagate it so that it is also run on the other servers in the grid. You cannot run the ifx_grid_procedure() procedure from within a transaction.

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

Example

The following example runs a procedure named myloadprocedure():

EXECUTE PROCEDURE ifx_grid_procedure('grid1',
	'myloadprocedure(2000)', 'mytag');