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:
- In the Data Project Explorer, right-click the User-Defined
Functions folder in a data development project, and click
. The New User-Defined Function wizard
opens.
- 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 Preferences page.
- 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.