For example, a Java™ application might batch heterogeneous SQL statements by passing them to a Statement.addBatch() method. The application generates these statements with SQL literal values rather than host parameter markers. When captureMode is ON, each of these statements might be captured. However, if the application is unlikely to run these identical statements when executionMode is STATIC, pureQuery does not need to capture all of them. In a situation like this, you should set allowDynamicSQL to TRUE so that the application can run the generated statements dynamically, rather than statically.
This property can take these values:
DDL statements, SELECT statements, and XQuery expressions are not affected by this option. All of these types of statements are captured.
When using DB2® Call Level Interface (CLI) or the IBM® Data Server Driver with pureQuery Runtime, you can use the pureQuery Runtime property as a configuration keyword.