Usage - Teradata Vantage - Analytics Database

Here are the steps to develop, compile, install, and use an external stored procedure:

1. Write, test, and debug the C, C++, or Java code for the procedure.
2. If you are using Java, place the class or classes for the external stored procedure 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 PROCEDURE or REPLACE PROCEDURE for external stored procedures to create a database object for the external stored procedure.
4. Use GRANT to grant privileges to users who are authorized to use the external stored procedure.
5. Invoke the procedure using the CALL statement.