Server to Client Transfer - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities

To retrieve one or more rows containing LOB data using the deferred 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 keep_resp = 'Y'.
  3. Set return_object to 'T' to indicate that transaction-related locators should be returned (or 'S' for static locators).
  4. Issue the SQL request (including one or more SELECTs) using DBCHCL (DBFIRQ).
  5. After the request completes, retrieve the requisite parcel sequence along with the non-LOB columns of the answer set using DBCHCL (DBFFET). The LOB columns will not contain LOB data but, rather, LOB locators.
  6. If the application desires to receive LOB data at this point, continue with step 7. Otherwise, either continue receiving non-LOB data or end the request.
  7. Issue the SQL SELECT request using the LOB locator returned in a previous response (for example, USING (A BLOB AS LOCATOR) SELECT :A;).
    This SELECT must be issued on the same session.
  8. When appropriate, retrieve the requisite parcel sequence along with the answer set using DBCHCL (DBFFET) until an EndMultipartRecord parcel is received.
  9. Issue DBCHCL (DBFERQ) to end the request.