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