In the previous lesson, you exported your Java application to the C:\pureQuery-test directory on your computer and ran the application against the SAMPLE DB2® database.
In this lesson, you configure your Java environment and enable your application with pureQuery client optimization. You capture SQL statements from your application and configure pureQuery Runtime and the target database to run the SQL statements issued by your application statically.
In this lesson, you configured a pureQueryXML file that contained SQL queries. When you configure a pureQueryXML file that contains DDL statements, the DDL statements, with exception of DECLARE GLOBAL TEMPORARY TABLE, are moved to a separate file. For example, you captured an SQL statement that created a table in your pureQueryXML file. When you configure the file the statement creating a table is moved to a separate file. For information about how the pureQuery Configure utility handles DDL statements, see Configure utility.
In a workbench Java project enabled with pureQuery support, the pureQueryXML file configuration process handles DDL statements in the same manner as the Configure utility.
For information about setting pureQuery Runtime properties, see Order of precedence for the locations in which you can set properties for client optimization.
For information about the pureQuery Runtime property finalRepositoryProperties, see finalRepositoryProperties property.