ifx_grid_procedure() procedure

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

Syntax


>>-EXECUTE PROCEDURE--ifx_grid_procedure--(--'--grid_name--'---->

>--,--'--procedure_text--'--+--------------+--)--;-------------><
                            '-,--'--tag--'-'

Element	Purpose	Restrictions
`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');