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.