UDX Options

These constants are used by the getOptions() method to modify the behavior of a UDX.

Table 1. getOptions Method Constants
Option	Description
OPT_DETERMINISTIC	A deterministic UDX always returns the same value for a given input. This allows the Netezza database to avoid calling the UDX multiple times if the arguments are the same. This option can be set to true or false.
OPT_NULL_INPUT	When set to false, a UDSF will return NULL if any of the arguments are NULL (the evaluate() method will not be called). The default value for OPT_NULL_INPUT is true so that the evaluate() method will be called when any of the UDSF arguments are NULL.
OPT_PARALLEL	For a table function, setting OPT_PARALLEL=false forces the table function to run on the host as a single process instead of running in parallel on the SPUs.