17.10 - SQL Procedures - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
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.