Scalar User-Defined Functions

Sybase IQ supports simple scalar user-defined functions (UDFs) that can be used anywhere the SQRT function can be used.

These scalar UDFs can be deterministic, which means that for a given set of argument values the function always returns the same result value, or they can be nondeterministic scalar functions, which means that the same arguments can return different results.

Note:

The scalar UDF examples referenced in this chapter are installed with the IQ server, and can be found as .cxx files in $IQDIR15/samples/udf. You can also find them in the $IQDIR15/lib64/libudfexdynamically linkable library.

Declaring a Scalar UDF
Only a DBA, or someone with DBA authority can declare an in-process external UDF. There is also a new server startup option that allows an administrator to enable or disable this style of user-defined functions.
Defining a scalar UDF
The C/C++ code for defining a scalar user-defined function includes four mandatory pieces:

Created November 2, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com