SQL Stored Procedures - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Tools and Utilities
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
oxw1641281447623.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
vfj1470443597526
Product Category
Teradata Tools and Utilities

The application sends the statements composing a procedure to the database, where they are compiled and saved for subsequent execution. The application that creates the procedure must do the following:

  1. Ascertain whether the database supports stored procedures.
  2. Send a request containing the procedure that could exceed the maximum parcel size.
  3. Provide compilation options to the database.

To ascertain if the database supports stored procedures, the DBCHQE CLIv2-limits query (or the deprecated Maximum-segment-size query) is used. If the segment length value returned by CLIv2-limits is zero, then SQL Stored Procedures are not supported (the deprecated Maximum-segment-size query fails with a return code 359 if such procedures are not supported).