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.

Before you create user-defined functions, you must complete some setup steps. See Prerequisites for developing 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 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