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.
The following client software packages support procedure execution and DDL operations:
- BTEQ
- CLIv2
- JDBC
- ODBC
- PreProcessor2
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.