Navigation:  Advantage Data Architect > Databases > User Defined Functions >

Creating or Modifying a User Defined Function

Advantage Data Architect

Previous pageReturn to chapter overviewNext page

A User Defined Function (UDF) allows a developer to create a reusable function that can be used in an SQL statement or script just like an existing scalar function. By encapsulating frequently performed or complex operations into UDFs, SQL statements and scripts become easier to write, understand, and debug. In a sense, UDFs makes it possible to extend the functionality of the SQL engine. The Connection Repository will allow UDFs to to be added to your database.

To create or modify a UDF, open a database. See Opening a Database for details. You must be logged into the database as a user with the CREATE FUNCTION or ALTER permission to add or modify UDFs.

To add a new UDF, from the tree view within the Connection Repository, right-click the FUNCTION icon and select Create Function.

To modify a UDF, from the tree view within the Connection Repository, right-click on the function and select Properties.

User Defined Function Field Descriptions

Name (required)

Enter the name for the UDF. This will be the name used to invoke the function.


Enter input and result parameters for the function in this grid.


Enter one or more SQL statements to be executed when the function is invoked.


Click OK to add the UDF to the database or modify an existing UDF.


Cancels the current operation and exits the screen.

See Also

Deleting a User Defined Function