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.