StreamGetData CLI/ODBC and IBM data server driver configuration keyword
Optimizes data output stream for SQLGetData() function.
- db2cli.ini keyword syntax:
- StreamGetData = 0 | 1
- IBM data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="StreamGetData" value="0 | 1"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- CLI buffers all the data on the client.
- Equivalent connection or statement attribute:
- SQL_ATTR_STREAM_GETDATA
- Usage notes:
- The StreamGetData keyword is ignored if Dynamic Data Format, also known as progressive
streaming, is not supported by the server. For applications that do not need to buffer data and are
querying data on a server that supports Dynamic Data Format, specify 1 to indicate that data
buffering is not required. The CLI client will optimize
the data output stream.
If StreamGetData is set to 1 and CLI cannot determine the number of bytes still available to return in the output buffer,
SQLGetData()returns SQL_NO_TOTAL (-4) as the length when truncation occurs. Otherwise,SQLGetData()returns the number of bytes still available.