Creating non-PL/SQL user-defined functions (UDFs)

You can create a non-PL/SQL 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 non-PL/SQL 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 non-PL/SQL user-defined function from the Data Source Explorer, you can use the routine editor or the SQL and XQuery editor.

Before you create non-PL/SQL 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