|
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
|