17.10 - Summary - 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.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)
  Client to Server Transfer Server to Client Transfer
Inline Mode
  • Requires Multipart Indicator response mode
  • Uses MultipartData or MultipartIndicData parcels (with EndMultipartData or EndMultipartIndicData parcels)
  • Maximum parcel size limited to maximum message size (~64K)
  • Single, discrete request
  • Requires Multipart Indicator response mode
  • Uses MultipartRecord parcel (with EndMultipartRecord parcel)
  • No practical size limit
  • Signaled by setting Return_object to 'D' in DBCAREA (default)
  • Single, discrete request
  • In the case of inline LOBs, the maximum size of a MultipartRecord parcel is 64 KB. So, if a LOB column is more than 64 KB, it will be split into 2 MultipartRecord parcels.
Deferred Mode
  • Requires Multipart Indicator response mode
  • Uses MultipartData or MultipartIndicData parcels (with EndMultipartData or EndMultipartIndicData parcels)
  • No practical size limit
  • Data elicited by server
  • Elicited data sent using DBFCRQ
  • Signaled by specifying AS DEFERRED in USING clause
  • Single, discrete request
  • Same protocol to be used by UDF
  • Requires Multipart Indicator response mode
  • Uses MultipartRecord parcel (with EndMultipartRecord parcel)
  • No practical size limit
  • Signaled by setting Return_object to 'T' (for transaction-related locator) or 'S' (for spool-related locator) in DBCAREA
  • Multiple, separate requests: one for the non-LOB data and one for each LOB column to be returned