Use the New User-Defined Function wizard to create a new user-defined function.
- Name
- Type a name for the user-defined function. The name can be qualified with a schema name, and contain letters and numbers but must start with a letter. The user-defined function name can be delimited with quotation marks to preserve lowercase characters or spaces. This name does not have to be unique within the database, but you cannot create a user-defined function with the exact same name and signature.
- Project
- Select the data development project that is associated with the connection that you are currently using in the Data Source Explorer. The projects available are existing development projects that are associated with the same connection that you are working with in the Data Source Explorer. The new user-defined function will be created in the selected development project.
- New
- Opens the New Project window, where you can create a new project that is associated with the connection that you are currently using in the Data Source Explorer.
- Language
- Shows that the language for the user-defined function.
- XML table user-defined function
- Creates a DB2® table user-defined function that read an XML document and returns data in a relational table format. For DB2 Linux®, UNIX®, and Windows® V9,7 SQL and Java™.