pureQuery keywords supported by CLI applications

When you enable a CLI application with pureQuery client optimization, you configure the pureQuery client optimization by specifying keywords and values in the application configuration file.
The following table lists the pureQuery Runtime properties that can be used with CLI applications as CLI keywords. Not all pureQuery Runtime properties are supported by CLI application that are enabled with pureQuery client optimization.
Table 1. pureQuery properties supported by CLI enabled with pureQuery client optimization
Property Description
allowDynamicSQL Specifies whether to allow an application to run dynamically any SQL statements that are not captured in a pureQueryXML file or that are captured but not bound.
capturedOnly Specifies whether to run only the SQL statements that are in the pureQueryXML file.
captureMode Specifies whether to capture information about SQL statements.
enableDynamicSQLReplacement Specifies whether to run alternative SQL statements that were added to a pureQueryXML file and both the original statements and the alternative statements were not bound.
executionMode Specifies whether to run statically the SQL statements that have been previously captured and stored by pureQuery Runtime.
maxNonParmSQL Specifies the maximum number of non-parameterized SQL statements to capture. This option applies only when the value of captureMode is ON. When captureMode is OFF, pureQuery ignores this parameter.
pureQueryXml Specifies the fully-qualified or relative path to and name of a file that is to be created by the process of capturing SQL statements or that already exists as a result of that process.
sqlLiteralSubstitution Specifies whether perform literal substitution. pureQuery Runtime attempts to replace literal values in SQL statements with parameter markers and capture the parameterized versions of the statements.
traceFile Specifies the physical file to write the log into. You can use an absolute path or a path that is relative to the directory in which the pureQuery Log utility runs.
traceLevel Specifies the level of detail to write to the log file.

Feedback