DB2 Version 9.7 for Linux, UNIX, and Windows

ColumnwiseMRI CLI/ODBC configuration keyword

In DB2® Version 9.7 Fix Pack 5 and later fix packs, this 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. Therefore, you can use this conversion to optimize 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 this conversion:

[dsn-name]
...
ColumnwiseMRI=ON

The conversion is not performed in certain cases. For details about these cases, see SQL_ATTR_COLUMNWISE_MRI.

This keyword only affects DB2 for z/OS servers.