FairCom Java & .NET Stored Procedures

SqlUdf

SqlUdf is the class that implements a User Defined Function (UDF). To create a UDF, a new class derived from SqlUdf class must be created. This class must implement the Execute() method, which is the method called by the server. The Visual Studio Extension automatically performs the following:

• It generates the class.
• It generates the Execute() method and adds proper code to exchange the UDF parameters and return code.
• It creates an ExecuteSP method, which is the method to be implemented.

SqlUdf Class Description

This class inherits from SqlSpBase. It adds the following additional methods.

Constructor

SqlUdf()

Public Methods

void SetReturnValue(Object obj)

Set the UDF return value.