DB2 Version 9 for Linux, UNIX, and Windows

Creating user-defined functions (UDFs)

You can create a user-defined function from a data development project in the Data Project Explorer, or you can create a user-defined function from a connection in the Database Explorer.

If you create a user-defined function from a data development project, you can use a wizard to guide you through the entire process, or you can simply specify a name and language for the user-defined function and then modify the source code in the routine editor. If you create a user-defined function from the Database Explorer, you can use the routine editor or the SQL editor.

Related concepts
Comparing and modifying routines
Related tasks
Using Visual Explain for routines
Related reference
Authorities for DB2 stored procedures and user-defined functions
Stored procedure and user-defined function support by server type
Related information
Changing default options for stored procedure and UDF development



Feedback

Update icon Last updated for DB2 Version 9.1