StreamPutData CLI/ODBC configuration keyword

db2cli.ini keyword syntax:

StreamPutData = 0 | 1

Default setting:

Do not write data directly to the connection-level buffer; write to the default statement-level buffer instead.

Usage notes:

 

By default, CLI writes data passed in through SQLPutData() function calls to an internal statement-level buffer. On the subsequent SQLParamData() call, the contents of the buffer are then written to an internal connection-level communication buffer and sent to the server. If only one statement handle is used to insert data into a target database on a particular connection at a given point in time, then you can improve performance by setting StreamPutData=1. This causes CLI to write the put data directly to the connection-level buffer. If, however, multiple statements concurrently insert data into a target database on a particular connection, then setting StreamPutData=1 may decrease performance and result in unexpected application errors, as the statements in the shared connection-level communication buffer will be prone to serialization.