Application Development Guide

Writing User-Defined Functions (UDFs) and Methods

  • Description
  • Interface between DB2 and a UDF
  • The Arguments Passed from DB2 to a UDF
  • Summary of UDF Argument Use
  • How the SQL Data Types are Passed to a UDF
  • Writing Scratchpads on 32-bit and 64-bit Platforms
  • The UDF Include File: sqludf.h
  • Creating and Using Java User-Defined Functions
  • Coding a Java UDF
  • Changing How a Java UDF Runs
  • Table Function Execution Model for Java
  • Writing OLE Automation UDFs
  • Creating and Registering OLE Automation UDFs
  • Object Instance and Scratchpad Considerations
  • How the SQL Data Types are Passed to an OLE Automation UDF
  • Implementing OLE Automation UDFs in BASIC and C++
  • OLE Automation UDFs in BASIC
  • OLE Automation UDFs in C++
  • OLE DB Table Functions
  • Creating an OLE DB Table Function
  • Fully Qualified Rowset Names
  • Defining a Server Name for an OLE DB Provider
  • Defining a User Mapping
  • Supported OLE DB Data Types
  • Scratchpad Considerations
  • Table Function Considerations
  • Table Function Error Processing
  • Scalar Function Error Processing
  • Using LOB Locators as UDF Parameters or Results
  • Scenarios for Using LOB Locators
  • Other Coding Considerations
  • Hints and Tips
  • UDF Restrictions and Caveats
  • Examples of UDF Code
  • Example: Integer Divide Operator
  • Example: Fold the CLOB, Find the Vowel
  • Example: Counter
  • Example: Weather Table Function
  • Example: Function using LOB locators
  • Example: Counter OLE Automation UDF in BASIC
  • Example: Counter OLE Automation UDF in C++
  • Example: Mail OLE Automation Table Function in BASIC
  • Debugging your UDF

    • [ Top of Page | Previous Page | Next Page ]