Application Building Guide

User-Defined Functions (UDFs)

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:

udfsrv

creates a library of user-defined functions (UDFs). It is available for C and C++ only. The client application, udfcli, calls these functions.

udf

creates a library of user-defined functions (UDFs). It is available for COBOL only. The client application, calludf, calls these functions.

UDFsrv

creates a library of user-defined functions (UDFs). It is available 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)".