Supplying Routine Modifiers

When you register purpose functions, you can specify optional routine modifiers in the CREATE FUNCTION statement using the WITH keyword. These routine modifiers allow you to specify certain attributes of function behavior.

PARALLELIZABLE Routine Modifier

The PARALLELIZABLE routine modifier indicates that you have designed the function to execute safely in parallel. Parallel execution can dramatically speed the throughput of data. The following example adds the PARALLELIZABLE modifier to a CREATE FUNCTION statement.

CREATE FUNCTION open_virtual(pointer) 
RETURNING integer
WITH (PARALLELIZABLE)
EXTERNAL NAME
   '$INFORMIXDIR/extend/amBlade/my_virtual.bld(open_virtual)'
LANGUAGE C

Important:

By itself, the routine modifier does not make your purpose function parallelizable. The function must also be designed in such a way that it can safely execute in parallel. For more information about parallel execution of functions that belong to an access method, refer to Executing in Parallel.