17.10 - SQL Procedures - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
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.