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 Data Source 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 Data Source Explorer, you can use the routine editor or the SQL editor.

Before you create user-defined functions, you must complete some setup steps. See Preparing to develop routines for more information.

User-defined function development is not supported for every available data source. See Stored procedure and user-defined function support by server type for details.

To create user-defined functions, you must have the required authorities and privileges. See Authorities for DB2 stored procedures and user-defined functions for details.

Related concepts
Comparing and modifying routines
Related tasks
Using Visual Explain for routines
Prerequisites for developing Java stored procedures
Prerequisites for developing routines on Linux
Prerequisites for developing routines that target DB2 for z/OS
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