17.00 - SQL Procedures - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K
SQL procedures are database objects executed on Vantage. Typically, SQL procedures consist of:
  • a procedure name
  • input and output parameters
  • procedure body

For more information see Teradata Vantage™ - SQL Stored Procedures and Embedded SQL , B035-1148 .

For each SQL procedure, the database includes an SQL procedure table that contains the SQL procedure body you write and the corresponding compiled object code. Data dictionary tables contain procedure parameters and attributes.

The Transient Journal (TJ) record holds the host request number for a procedure, in addition to the DBS request number, to return a correct response to the query status for a request after DBS restarts.