Porting applications that use client optimization from one version of DB2 to another

There are two strategies that you can use for developing SQL statements so that you can port your non-pureQuery API application from one DB2® version to another.

These strategies are not guaranteed to work in every situation.

First strategy
  • Use only the SQL capabilities that are described by the The SQL Reference for Cross-Platform Development.
  • Re-create the pureQueryXML file for each data source, and each version of the data source, that the application will be run against. Then, use the appropriate pureQueryXML file with the matching server and version.
Alternate strategy
Be sure that the application uses only a least-common-denominator of the capabilities of all target servers and versions. Perform the capture process on the system with the least capabilities.

Feedback