Description - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
ttt1608578409164.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
lifecycle
previous
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.