Utilities and APIs Supporting CREATE/REPLACE PROCEDURE - Advanced SQL Engine - Teradata Database

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.