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
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities
 

 

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