Using Data Studio pureQuery is another way for Java™ Persistence API (JPA) to access a DB2® and Informix® databases. PureQuery supports static Structured Query Language (SQL).
<property name="openjpa.jdbc.DBDictionary" value="batchLimit=100"/>
The Feature Pack for OSGi Applications and Java Persistence API (JPA) 2.0 introduces support for pureQuery 2.2.0.2 and later. The new feature added for PureQuery 2.2.0.3, supports Informix, and DB2 applications to use pureQuery in DYNAMIC mode.
This is achieved by setting up pdqProperties on the data source in the Java Enterprise Edition (Java EE) environment. Or, setting pdqProperties on the connection URL in the Java Standard Edition (Java SE) environment.
If pdqProperties is not defined, pureQuery runs in compatible mode, which means that the pdqxml file is packaged in the application Java archive (JAR) files.
There are several topics that reference pdqProperties in the IBM® Integrated Data Management information center.
In this information ...Related tasks
| IBM Redbooks, demos, education, and more(Index) |