Blocking considerations

When you want to turn blocking off for an embedded SQL application and the source code is not available, the application must be rebound using the BIND command and setting the BLOCKING NO clause.

Existing embedded SQL applications must be rebound using the BIND command and setting the BLOCKING ALL or BLOCKING UNAMBIGUOUS clauses to request blocking (if they are not already bound in this fashion). Embedded applications will retrieve the LOB values from the server a row at a time, when a block of rows have been retrieved from the server