One DBCAREA - 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.00
Published
June 2020
Language
English (United States)
Last Update
2021-04-19
dita:mapPath
xen1544831946512.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

If the application program is facing space limitations, then one DBCAREA can be reused (at the expense of added cpu time). This entails copying the Output Request Ids, saving them, and replacing them when doing a Fetch, Rewind, or Cancel against that same Teradata SQL request. If other fields, such as the processing options or buffer addresses or sizes, change from one request to another, they too must be saved and replaced. Because much less information than the whole DBCAREA is saved, the application program can show a significant saving of space at the small cost of unloading and reloading those fields between calls.