EnableStaticSQLCapture IBM data server driver configuration keyword
Specifies whether the application will capture SQL or use a static SQL Package for this DSN.
- Equivalent CLI keyword
- StaticMode
- Equivalent IBM® Data Server Provider for .NET connection string keyword
- Not available.
- db2dsdriver.cfg configuration syntax
<parameter name="EnableStaticSQLCapture" value="DISABLED | CAPTURE | MATCH"/>- 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 application for this DSN will be processed:
- DISABLED = Static mode disabled. No special processing. The statements will be executed as dynamic SQL with no change. This is the default.
- CAPTURE = Capture Mode. Execute the 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.