Replenishing the Response Buffer - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
ggf1488824663364.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

CLI automatically replenishes the response buffer(s). That is, the Teradata Database application program may call DBCHCL for the Fetch function repeatedly. The response buffer(s) may or may not be large enough to hold all the parcels in the response, but the application program can draw on them as if they are.

If the application program calls DBCHCL for the Rewind function, the pointer that moves back to the first parcel is a pointer in the response stored on a spool file in the Teradata Database, not a pointer in the response stored in the response buffer(s). Therefore, if rewinding may take place, it is important to operate with Keep Response set to Y, even if the whole response can fit in the response buffer(s).

Set the receive queue buffer size by setting environment variable TCP_BUF_SIZE.

Use environment variable COPANOMLOG to get the log information to see the values of sizes of send/receive queue buffer.

See the Teradata Tools and Utilities Installation Guide for the appropriate operating system for information how to set TCP_BUF_SIZE.