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

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

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.