Batch Execution

Functions
int	kdbc_add_batch (kdbc_stmt *stmt)
	Add current parameters as a batch entry.
int	kdbc_execute_batch (kdbc_stmt *stmt)
	Execute all batched parameter sets.

Detailed Description

Execute multiple parameter sets in a single statement.

kdbc_stmt *stmt = kdbc_prepare(conn, "INSERT INTO t (val) VALUES (?)");
for (int i = 0; i < 100; i++) {
    kdbc_bind_int(stmt, 1, i);
    kdbc_add_batch(stmt);
}
int total = kdbc_execute_batch(stmt);
kdbc_stmt_close(stmt);

Function Documentation

kdbc_add_batch()

int kdbc_add_batch

(

kdbc_stmt *

stmt

)

Add current parameters as a batch entry.

After calling this, bind new parameter values and call again for the next row. Finally call kdbc_execute_batch() to execute all rows.

Parameters

stmt	A prepared statement with parameters bound.

Returns

KDBC_OK or KDBC_ERROR.

kdbc_execute_batch()

int kdbc_execute_batch

(

kdbc_stmt *

stmt

)

Execute all batched parameter sets.

Parameters

stmt	A prepared statement with batched entries.

Returns

Total number of affected rows, or KDBC_ERROR on failure.