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
- 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.