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.