Utilities and APIs Supporting CREATE/REPLACE PROCEDURE - Analytics Database - Teradata Vantage

You can create a procedure using the COMPILE command in BTEQ and BTEQWIN. See Basic Teradata® Query Reference, B035-2414.

You can also create a procedure using the CREATE PROCEDURE statement from CLIv2, ODBC, and JDBC applications.

For details on the use of local variables and condition handlers in SQL procedures, see the description of DECLARE and DECLARE HANDLER statements in Teradata Vantage™ - SQL Stored Procedures and Embedded SQL, B035-1148.