ifx_grid_function() function

The ifx_grid_function() function propagates the execution of a function to all servers in the grid.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--ifx_grid_function--(--'--grid_name--'------>

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

Element Purpose Restrictions
grid_name Name of the grid. Must be the name of an existing grid.
function_text The text format of the function to be run.  
tag A character string to identify grid operations.  

Usage

Use the ifx_grid_function() function to run a function or SQL statement on a source server and propagate it so that it is also run on the other servers in the grid. The output of the function is returned to the client application as an LVARCHAR data type with comma-delimited text. You can also view the output with the cdr list grid command with the --verbose option. You cannot run the ifx_grid_function() function 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 function named load_function():

EXECUTE FUNCTION ifx_grid_function('grid1', 'load_function(2000)');

Copyright© 2018 HCL Technologies Limited