16.20 - Utilities and APIs Supporting CREATE/REPLACE PROCEDURE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
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, and from the Teradata SQL Assistant utility.

The following client software packages support procedure execution and DDL operations:
  • BTEQ
  • CLIv2
  • JDBC
  • ODBC
  • PreProcessor2
  • Teradata SQL Assistant

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 .