DB2 Version 10.1 for Linux, UNIX, and Windows
DB2 Version 10.1 for Linux, UNIX, and Windows
Gets or sets the number of commands in a batch to be sent to the database server for execution.
[Visual Basic]
Public Overrides Property UpdateBatchSize As Integer
[C#]
public override int UpdateBatchSize { get; set; }
[C++]
public:
virtual property int UpdateBatchSize {
int get () override;
void set (int value) override;
}
[JScript]
public override function get UpdateBatchSize () : int
public override function set UpdateBatchSize (value : int)| Value | Behavior |
|---|---|
| 0 | The entire update is executed in a single batch. |
| 1 | Disable batch processing. Each update is sent to the database individually. |
| > 1 | The number of commands to execute as a batch before starting a new batch. If this value is greater than the number of rows, the update will be done as a single batch. |
[C#] The following lines of code result in a batch size of 99.
[C#]
DB2DataAdapter adapter = new DB2DataAdapter();
adapter.UpdateBatchSize = 99;