Maximum Response Size - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Maximum Response Size

The maximum size of the response data that may be fetched by the application has been increased several times, but to ensure compatibility for existing CLIv2 applications, the acceptability of these increases must be indicated in the DBCAREA.

The default DBCAREA Maximum‑parcel option value of 'O' limits fetched response data to 32767 bytes. Specifying a value of 'H' allows a maximum of 65535 bytes. If the size of the fetched response data exceeds 32767, but Maximum‑parcel is not 'H' then the Database returns a 3115 error to the application.

The default DBCAREA APH‑response‑OK option value of 'N' limits fetched response data to 65535 bytes. Specifying a value of 'Y' allows a maximum of 2,147,483,647 bytes. If the size of the fetched response data exceeds 65535, but Maximum‑parcel is not 'H' then the Database returns a 3177 error to the application.