With Rogue Wave DB Link, your application can handle Large OBjects (LOBs) either as a whole or in memory chunks.

LOBs can be sent to the RDBMS only from memory-stored data, but they can be retrieved as a whole into memory or as whole into a named file, or in chunks into application-allocated memory.

Retrieving LOBs in chunks depends on the RDBMS: most RDBMSs allow retrieval only in consecutive chunks. The only exception to this is Oracle whose API supports positioned retrieval.

The various RDBMSs use different type names for LOBs and have different protocols to send and retrieve these kinds of values. The term LOB is used for data types that allow values of unlimited size. (This is theoretical. In practice, the size is always limited to two gigabytes).

This section is divided in 2 parts: