ifx_grid_procedure() procedure
The ifx_grid_procedure() procedure propagates the execution of a procedure to all servers in the grid.
Syntax
EXECUTE PROCEDUREifx_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');