Binding parameter markers in CLI applications with column-wise array input
To process an SQL statement that
will be repeated with different values, you can use column-wise array
input to achieve bulk inserts, deletes, or updates.
This
results in fewer network flows to the server because
SQLExecute()
does
not have to be called repeatedly on the same SQL statement for each
value. Column-wise array input allows arrays of storage locations
to be bound to parameter markers. A different array is bound to each
parameter. Before you begin
About this task
SQLBindParameter()
call
to indicate to CLI the
location of values in the input array. For other input data types,
the length of each element in the array is assumed to be the size
of the C data type. Procedure
To bind parameter markers using column-wise array input: