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.