Usage - Teradata Vantage - Analytics Database

To create and use an SQL UDF, follow these steps:

1. Use CREATE FUNCTION or REPLACE FUNCTION to define the UDF.
2. Use GRANT to grant privileges to users who are authorized to use the UDF.
3. Call the function.

To develop, compile, install, and use an external UDF, follow these steps:

1. Write, test, and debug the C, C++, or Java code for the UDF.
2. If you are using Java, put the class or classes for the UDF in an archive file (JAR or ZIP) and call the SQLJ.INSTALL_JAR external stored procedure to register the archive file with the database.
3. Use CREATE FUNCTION or REPLACE FUNCTION to create a database object for the UDF.
4. Use GRANT to grant privileges to users who are authorized to use the UDF.
5. Call the function.