Description - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities
If... Then...
stored procedures are not supported the service will fail (return code 374).
are supported a four-byte unsigned binary value is returned that indicates the maximum size of a data segment (in bytes).

In such cases, if the size of the stored procedure exceeds this value, it must be sent as multiple requests, each of which sends data no larger than this value.

The application sends the statements comprising 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 whether the database supports stored procedures, the CLIv2 Query service obtains the Server Maximum Segment Size. Based on the results returned by the Query service, one of the actions described in the next sections occurs.