AllowInterleavedGetData IBM data server driver configuration keyword
Specifies whether the application can call SQLGetData() for
previously accessed LOB columns and maintain the data offset position
from the previous call to SQLGetData() when
querying data servers that support Dynamic Data Format.
- Equivalent CLI keyword
- AllowInterleavedGetData
- Equivalent IBM® Data Server Provider for .NET connection string keyword
- N/A
- db2dsdriver.cfg configuration syntax
<parameter name="AllowInterleavedGetData" value="FALSE | TRUE"/>- Default setting:
- Does not allow calls to
SQLGetData()for previously accessed LOB columns when querying database servers that support Dynamic Data Format. - Usage notes:
- This keyword affects only connections to database servers that
support Dynamic Data Format, also known as progressive streaming.
The default setting of FALSE does not allow applications to call
SQLGetData()for previously accessed LOB columns. Specify TRUE to allow applications to callSQLGetData()for previously accessed LOB columns and start reading LOB data from where the application stopped reading during the previous read.Note that when the keyword is set to TRUE to allow re-access to LOB columns, some resources on the server might not be freed upon completion of
SQLGetData().If the server does not support Dynamic Data Format, this keyword has no effect, and calls to
SQLGetData()for previously accessed LOB columns are allowed.A similar keyword exists called AllowGetDataLOBReaccess that allows applications to call
SQLGetData()for previously accessed LOB columns. However, if the AllowGetDataLOBReaccess keyword is used, data position and offset information is not maintained. When the LOB column is re-accessed after interleaving,SQLGetData()starts reading data from the beginning for that LOB data column. If both AllowGetDataLOBReaccess and AllowInterleavedGetData are set, the AllowInterleavedGetData setting takes precedence over AllowGetDataLOBReaccess.