You export your Java™ application
to your file system and configure the application with pureQuery client
optimization. You also run pureQuery Runtime utilities to enable the
application to run SQL statements statically on the SAMPLE DB2® database.
Learning objectives
After you complete
this module, you will be able to do the following tasks:
- Export your application from the workbench to your computer.
- Configure your Java environment
to run an application that is enabled with pureQuery client optimization.
- Capture SQL statement in a pureQueryXML file by setting pureQuery
Runtime properties and running your application.
- Configure the SAMPLE DB2 database
and your application to support running SQL statements statically.
- Run SQL statements from your application statically.
Time required
This module takes approximately
30 minutes to complete.
System requirements
This module requires:
- IBM® Optim™ Development Studio Version 2.2.1
- DB2 Enterprise Server Edition
Version 9.5 Fix Pack 3
- The DB2 SAMPLE database.
Information about creating the database is located at Creating the sample database (Link to the DB2 information center)
- pureQuery Runtime Version 2.2.1
- IBM Data Server Driver for
JDBC and SQLJ Version 3.57