16.20 - SQL Procedures - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
SQL procedures are database objects executed on the Teradata Database. 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.