Index
Special characters
A
B
C
D
F
I
J
O
P
R
S
W
Special characters
A
B
- bind privileges
- bindOptions
C
- CLI with pureQuery Runtime
- client optimization
- allowDynamicSQL (1), (2), (3)
- alternative SQL statements
- application maintenance, recommendations
- application migration, recommendations
- applications running with different application servers
- benefits
- benefits of static SQL
- capturedOnly (1), (2), (3)
- captureMode (1), (2), (3), (4)
- captureStatementBatchSQL (1), (2)
- capturing from Web applications that share data sources
- capturing SQL data
- capturing SQL statements (1), (2)
- capturing SQL statements from clustered applcations
- configuring a WebSphere Application Server
- configuring and binding, recommendations
- configuring and binding a pureQueryXML file
- creating a repository
- database schema support, recommendations
- DDL statements
- description
- enableDynamicSQLReplacement (1), (2), (3), (4)
- enabling a Java application
- enabling a WebSphere Application Server
- enabling with an application
- example
- examples of setting runtime properties
- executionMode (1), (2), (3), (4)
- files for captured SQL statements
- incremental capture
- Java environment
- marking statement sets as final
- maxNonParmSQL (1), (2)
- maxStackTracesCaptured (1), (2)
- merging SQL data from a repository
- merging statement sets within pureQueryXML files
- migrating from test to production
- order of precedence for runtime properties
- outputPureQueryXml
- overview of steps
- packagePrefixExclusions (1), (2)
- pdq.properties file
- porting applications
- potential causes for problems
- prerequisites
- properties
- pureQueryXml (1), (2), (3), (4)
- pureQueryXML
- pureQueryXML files
- recommendations
- running captured and non-captured SQL statements dynamically
- running captured SQL statements dynamically (1), (2)
- running non-pureQuery API applications
- running SQL statements dynamically
- running SQL statements statically
- running statically SQL statements that are captured and bound (1), (2), (3), (4), (5)
- setting data source properties
- setting properties in a repository
- setting runtime properties
- SQL, dynamic and static execution (1), (2), (3)
- SQL, static execution
- sqlLiteralSubstitution
- stack traces for SQL statements
- stackTraceDepth
- storing pureQuery data
- supported pureQuery properties
- using a pdq.properties file
- using JVM system properties
- using the workbench
- WebSphere custom properties
- client optimization with the workbench
- collection
D
- DB2 packages
- support for static SQL in pureQuery
- DB2 special registers
- db2cli DB2 command, pureQuery examples
- db2cli DB2 command, pureQuery options
- Default.bindProps file
- for client optimization
- for client optimization with the workbench
- for JPA applications
- for pureQuery code development
- for pureQuery code development with the workbench
- Default.genProps file
- for client optimization
- for client optimization with the workbench
- for pureQuery code development
- for pureQuery code development with the workbench
F
I
J
- JUnit test cases in pureQuery
O
P
- propertiesRefreshInterval
- pureQuery (1), (2), (3)
- .NET applications (1), (2), (3)
- capturing and running SQL dynamically
- capturing and running SQL statements
- CLI and .NET applications (1), (2), (3)
- CLI applications (1), (2), (3), (4), (5), (6)
- client optimization (1), (2)
- creating a repository
- DB2 data sources
- DB2 special registers
- db2cli DB2 command (1), (2)
- db2cli DB2 command examples
- Informix data sources
- logging (1), (2), (3)
- properties for capturing and running SQL dynamically
- repository runtime groups
- SQL, dynamic and static execution (1), (2)
- SQL, static execution
- summary of properties
- using remote systems
- WebSphere custom properties
- pureQuery code development
- pureQuery code development with the workbench
- pureQuery Runtime properties
- pureQuery support for JPA applications (1), (2), (3)
- pureQueryXML
R
S
- special registers
- SQL Management repository
- SQL Management repository,
- SQL statements
- static SQL
- storing captured SQL information (1), (2), (3)
W