Application Building Guide
User-defined functions allow you to write your own extensions of SQL for
your own requirements. Like stored procedures, user-defined functions
are stored on the server to be accessed by client applications. UDFs do
not contain embedded SQL statements.
The following sample programs are used in this book to demonstrate the
steps for building and storing a UDF library on the server:
-
udf
- creates a library of user-defined functions (UDFs); calludf is
the client application that calls these functions.
-
UDFsrv
- creates a library of user-defined functions (UDFs) for Java only;
UDFcli, and UDFclie are the JDBC and SQLJ client
applications, respectively, that call these functions.
The following sections discuss building information for user-defined
functions for supported platforms and compilers:
- Java (all platforms)
- "User-Defined Functions (UDFs)".
- AIX IBM C
- "User-Defined Functions (UDFs)".
- AIX IBM C Set++
- "User-Defined Functions (UDFs)".
- AIX IBM VisualAge C++
- "User-Defined Functions (UDFs)"
- HP-UX C
- "User-Defined Functions (UDFs)".
- HP-UX C++
- "User-Defined Functions (UDFs)".
- Linux C
- "User-Defined Functions (UDFs)".
- Linux C++
- "User-Defined Functions (UDFs)".
- OS/2 IBM VisualAge C++ Version 3
- "User-Defined Functions (UDFs)".
- OS/2 IBM VisualAge C++ Version 4
- "User-Defined Functions (UDFs)"
- Solaris SPARCompiler C
- "User-Defined Functions (UDFs)".
- Solaris SPARCompiler C++
- "User-Defined Functions (UDFs)".
- Windows 32-bit Operating Systems Microsoft Visual C++
- "User-Defined Functions (UDFs)".
- Windows 32-bit Operating Systems IBM VisualAge C++ Version
3.5
- "User-Defined Functions (UDFs)".
- Windows 32-bit Operating Systems IBM VisualAge C++ Version
4.0
- "User-Defined Functions (UDFs)".
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]