DB2ConnectionStringBuilder.FetchBufferSize Property

Specifies the default query block size to optimize the data flow.

Namespace:: IBM.Data.DB2
Assembly:: IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax


[Visual&nbsp;Basic]
Public Property FetchBufferSize As String
[C#]
public string FetchBufferSize {get; set;}
[C++]
public: __property String* get_FetchBufferSize();
public: __property void set_FetchBufferSize(String*);
[JScript]
 public function get FetchBufferSize(): String;
public function set FetchBufferSize(String);

Property value

A string that represents query block size only in multiples of 32K (that is 64K, 96K, 128K, 160K, 192K, 224K, and 256K).

The FetchBufferSize value that is not in multiples of the 32K query block size is rounded up to the next nearest 32K boundary when they are within the range of 64K-256K. Value that is set outside the valid range (64K to 256K) is rounded to the next nearest 32K block size that is in the valid range.