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
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
ggf1488824663364.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
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