Server to Client Transfer
To retrieve one or more rows containing LOB data using the deferred method, a typical parcel mode CLI application should perform the following tasks:
1 Set the response mode (resp_mode) to 'M' to indicate Multipart Indicator response mode. Any other setting will result in an error condition being returned.
2 Set keep_resp = 'Y'.
3 Set return_object to 'T' to indicate that transaction-related locators should be returned (or 'S' for static locators).
4 Issue the SQL request (including one or more SELECTs) using DBCHCL (DBFIRQ).
5 After the request completes, retrieve the requisite parcel sequence along with the non-LOB columns of the answer set using DBCHCL (DBFFET). The LOB columns will not contain LOB data but, rather, LOB locators.
6 If the application desires to receive LOB data at this point, continue with step 7. Otherwise, either continue receiving non-LOB data or end the request.
7 Issue the SQL SELECT request using the LOB locator returned in a previous response (for example, USING (A BLOB AS LOCATOR) SELECT :A;).
Note: This SELECT must be issued on the same session.
8 When appropriate, retrieve the requisite parcel sequence along with the answer set using DBCHCL (DBFFET) until an EndMultipartRecord parcel is received.
9 Issue DBCHCL (DBFERQ) to end the request.