ColumnwiseMRI CLI/ODBC configuration keyword
Specifies whether array input chaining is converted to column-wise array input for Db2® for z/OS® servers.
- db2cli.ini keyword syntax:
- ColumnwiseMRI = ON | OFF
- Default setting:
- Conversion from array input chaining into column-wise array input is disabled.
- Equivalent connection attribute:
- SQL_ATTR_COLUMNWISE_MRI
- Usage notes:
- The multi-row insert (MRI) feature in Db2 for z/OS expects
data to be in column-wise array form for multi-row INSERT and MERGE
operations. The conversion from array input chaining into column-wise
array input optimizes performance in applications that use the array
input chaining feature because the data is sent in a compacted form.
The following example shows how to enable the conversion:
[dsn-name] ... ColumnwiseMRI=ONThe conversion does not take place in certain cases. See SQL_ATTR_COLUMNWISE_MRI for details.
The ColumnwiseMRI keyword has no effect unless you are connected to a Db2 for z/OS server.