Creating user-defined functions from the Data Project Explorer

You can use the New User-Defined Function wizard to create user-defined functions (UDFs).

Before you begin

You must create a data development project.

Procedure

To create a user-defined function from a data development project:

  1. In the Data Project Explorer, right-click the User-Defined Functions folder in a data development project, and click New > User-Defined Function. The New User-Defined Function wizard opens.
  2. Complete the steps of the wizard.

    If you opened the wizard by using the toolbar button, you must provide project and connection information in the wizard.

    After you specify a name and language, select a template to use as the starting point for your user-defined fuction. Some templates are included with the product, or you can create your own templates to share with other team members using the Routines > Templates Preferences page.

  3. Click Finish.

Results

The wizard creates the user-defined function and adds it to the User-Defined Functions folder, and the user-defined function opens in the routine editor.

By default, creating the user-defined function does not register the user-defined function on the database. To register the user-defined function on the database, you must deploy it.


Feedback