DB2 Version 9.7 for Linux, UNIX, and Windows

StreamGetData CLI/ODBC configuration keyword

Optimizes data output stream for SQLGetData() function.

db2cli.ini keyword syntax:
StreamGetData = 0 | 1
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.