SQLOverrideFileName CLI/ODBC and IBM data server driver configuration keyword

Specifies the location of the override file, which lists CLI statement attribute settings for particular SQL statements.

db2cli.ini keyword syntax:
SQLOverrideFileName = <absolute or relative path name>
IBM data server driver configuration file (db2dsdriver.cfg) syntax:
<parameter name="SQLOverrideFileName" value="absolute or relative path name"/>
Attention: The IBM data server driver configuration file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
Default setting:
No override file is used.
Usage notes:
 
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.