Use Sequential Retrieval Only

UseSequentialRetrievalOnly

Key Name Default Value Required

UseSequentialRetrievalOnly

Clear (0)0

No

Description

This option indicates to the connector whether you are retrieving LOB data from columns in sequential order or non-sequential order. When working in Smart LOB (SLOB) Mode, the connector reads and caches LOB data differently depending on this setting. For more information about SLOB Mode, see LOB Retrieval Modes.

  • Enabled (1)1: When working in SLOB Mode, the connector does not cache the other LOBs that it reads while looking for the one to be retrieved. Because the connector can retrieve LOBs in a single pass if they are queried sequentially, the connector does not need to cache them.
  • Disabled (0)0: When working in SLOB Mode, the connector caches the other LOBs that it reads while looking for the one to be retrieved. This caching allows the connector to successfully retrieve SLOBs in any order.
Important:

Important:

  • Do not enable this option if there is any possibility that you might retrieve LOBs from columns in a non-sequential order. For instance, do not enable this option and then execute a query that retrieves LOBs from the third column in a table, then from the first column, and then from the fifth column. If you enable this option and then retrieve LOBs non-sequentially, the connector discards the LOBs that are returned through SLOB Mode and must then retrieve them all again using Deferred Mode.
  • As an alternative to using this option, you can specify this setting on the statement level rather than the connection level by using the SQL_ATTR_USE_SEQUENTIAL_RETRIEVAL_ONLY statement attribute.

Related topics