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.