Creating user-defined functions (UDFs)

You can create a user-defined function from a data development project in the Data Project Explorer, or 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 SQL and XQuery editor. However, this is not the preferred method because the SQL and XQuery editor does not provide the full set of routine editing features that the routine editor provides.

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 Routine support by server type for details.

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


Feedback