StaticMode CLI/ODBC and IBM data server driver configuration keyword
Specifies whether the CLI/ODBC application will capture SQL or use a static SQL Package for this DSN.
- db2cli.ini keyword syntax:
- StaticMode = DISABLED | CAPTURE | MATCH
- IBM data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="StaticMode" value=" DISABLED | CAPTURE | MATCH"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- Disabled - SQL statements are not captured and no static SQL package is used.
- Usage notes:
This option allows you to specify how the SQL issued by
the CLI/ODBC application for this DSN will be processed:
- DISABLED = Static mode disabled. No special processing. The CLI/ODBC statements will be executed as dynamic SQL with no change. This is the default.
- CAPTURE = Capture Mode. Execute the CLI/ODBC statements as dynamic SQL. If the SQL statements are successful, they will be captured into a file (known as the Capture File) to be bound by the DB2CAP command later.
- MATCH = Match mode. Execute the CLI/ODBC statements as static SQL statements if a matching statement is found in the Capture Files specified in StaticPackage. The Capture File must first be bound by the DB2CAP command.