ipGetScalarFunctions

This is an optional method you can implement in your IP to register user-defined scalar functions. Setting Up the samples describes using example3 for a sample implementation.

Refer to "User Defined Scalar Functions" in Chapter 4 of the OpenAccess SDK SQL Engine Programmer's Guide for information on implementing user defined scalar functions.

scalar_functions[] ipGetScalarFunctions()

Table 22. Parameters for ipGetScalarFunctions
Parameter	Type	Description
RETURN
	scalar_functions[ ]	An array of scalar_functions used to register user defined scalar functions. The IP class must implement a method for each user defined scalar function and register the method's name.

Example

scalar_functions[] ipGetScalarFunctions()
{
    scalar_functions[] MyFuncs = new scalar_function[5];
    MyFuncs[0]=new scalar_function("INTVAL", 1, "ip_func_intval", XO_TYPE_INTEGER, 1);
    MyFuncs[1]=new scalar_function("DOUBLEVAL", 1, "ip_func_doubleval", XO_TYPE_DOUBLE, 1);
    MyFuncs[2] = new scalar_function("CHARVAL", 1, "ip_func_charval", XO_TYPE_CHAR, 1);
MyFuncs[3] = new scalar_function("INTEGER", "ADD", 1, "ip_func_Integer_add", XO_TYPE_INTEGER, 1);
MyFuncs[4] = new scalar_function("STRING", "ADD", 1, "ip_func_String_add", XO_TYPE_VARCHAR, 1);
    return MyFuncs;
}