Teradata allows you to create UDFs to extend your SQL functionality.
- In the Navigator, expand the Databases, right-click a database or user, and click Show User-Defined Functions. A list of the UDFs defined in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
In the Object List Viewer toolbar, click .
A Create User-Defined Function property form opens in the Details view.
- In the form, enter values for the new UDF.
- [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to create the new UDF.
- Click Commit.
- Click OK. The property form shows the properties of the new UDF.