SQLOverrideFileName CLI/ODBC configuration keyword

The SQLOverrideFileName keyword specifies the location of the override file to be read by the CLI driver. An override file contains values for CLI statement attributes that apply to particular SQL statements. For example, you can specify the SQLOverrideFileName keyword with path and the override file name in the db2cli.ini file.

[MyDatabase]
SQLOverrideFileName=C:\temp\myfile.txt

In the c:\temp\ path, you would have override file named myfile.txt, containing values for CLI statement attributes that applies to particular SQL statements. The override file would start with a COMMON section ([COMMON]) containing only one keyword called Stmts, which tells you how many statements to override. Following sample override file (myfile.txt) has two statements:

[Common]
Stmts=2

[1]
StmtIn=SELECT * FROM Employee
StmtAttr=SQL_ATTR_BLOCK_FOR_NROWS=50;SQL_ATTR_OPTIMIZE_FOR_NROWS=1;

[2]
StmtIn=SELECT * FROM Sales
StmtAttr=SQL_ATTR_MAX_ROWS=25;

The number specified by Stmts in the [COMMON] section of the override file equals the number of SQL statements contained in the override file.