Utilities and APIs Supporting CREATE/REPLACE PROCEDURE
You can create a procedure using the COMPILE command in BTEQ and BTEQWIN. See Basic Teradata Query Reference for details.
You can also create a procedure using the CREATE PROCEDURE statement from CLIv2, ODBC, and JDBC applications, and from the Teradata SQL Assistant utility.
Procedure execution and DDL operations are supported by the following client software.
For details on the use of local variables and condition handlers in SQL stored procedures, see the documentation for the DECLARE and DECLARE HANDLER statements in SQL Stored Procedures and Embedded SQL.