When you run your application with these settings, pureQuery checks whether a given SQL statement is already in the pureQueryXML file for the connection that the statement must run against.
If the statement does not use autogenerated keys and has an alternative SQL statement, pureQuery runs the alternative SQL statement statically.
Property | Setting |
---|---|
executionMode | STATIC |
enableDynamicSQLReplacement | TRUE |
pureQueryXml | file-name.pdqxml or file-name.xml |
This table does not show properties that you can leave at their default values or other properties that you might want to use. Here is a complete list of the properties that you can use when running SQL statements:
You can also set logging properties. See Descriptions of properties for logging and tracing.
See How to set properties for client optimization for information about how and where to set these properties.