Server to Client Transfer - 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
To retrieve one or more rows containing LOB data using the inline method, a typical parcel mode CLI application should perform the following tasks:
  1. Set the response mode (resp_mode) to 'M' to indicate Multipart Indicator response mode. Any other setting will result in an error condition being returned.
  2. Set return_object to 'D' to indicate that data - rather than locators - should be returned.
  3. Issue the SQL request (including one or more SELECTs) using DBCHCL (DBFIRQ) as before.
  4. After the request completes, retrieve the requisite parcel sequence along with the answer set using DBCHCL (DBFFET).
  5. Issue DBCHCL (DBFERQ) to close the request.