DB2 10.5 for Linux, UNIX, and Windows

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=ON

The 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.