Utilities for developing applications with pureQuery
pureQuery provides several utilities that you can use when
developing applications.
How to read syntax diagrams
The following information will help you to understand the
structure of syntax diagrams.
Requirements for running pureQuery utilities
You must configure your Java environment
to run the Java pureQuery Runtime utilities. To configure
your environment you can set environment variables or specify command
line options.
Configure utility
With the pureQuery Configure utility, you can set several
characteristics of the DB2® packages
that you eventually create for the SQL statements in your pureQueryXML
files. Characteristics you can set include the collection, version,
and root package name of DB2 packages,
and you can set the maximum number of SQL statements that are grouped
in a package. XML schema validation can also be performed on input
pureQueryXML files.
DataVersion utility
Use this utility to check whether your system is correctly
configured for using pureQuery.
Generator utility
The pureQuery Generator utility generates implementation
classes for interfaces that declare annotated methods.
GeneratePureQueryXml utility
The GeneratePureQueryXml utility generates a pureQueryXML
file from an input file. The input file can be an SQL script file
that contains statements and cursor attribute information or an InfoSphere® Optim™ Query Workload Tuner XML file.
ManageRepository utility
The ManageRepository utility creates a repository in a
database and manages the repository. The repository contains pureQuery
data used by pureQuery-enabled applications such as configuration
information and pureQueryXML data. The repository can store captured
SQL data from applications enabled with pureQuery client optimization.
Merge utility You can merge two or more pureQueryXML
files together that contain SQL statements that were captured from
an application and that run against a single data source. XML
schema validation can be performed on the input pureQueryXML files,
and unused SQL statements can be eliminated from the output merged
file.
StaticBinder utility, as used with annotated methods
If you are using the annotated-method programming style
and a DB2 database, you can
use the pureQuery StaticBinder utility to bind
the SQL statements in your annotated methods to that data source.
You can also use the StaticBinder utility to generate
DBRM files.
StaticBinder utility, as used for client optimization
With the StaticBinder utility, you can create and bind DB2 packages that contain the SQL
statements in your pureQueryXML files. You can also choose to create
DBRM files that you can later transfer to a z/OS® data set and use to create DB2 packages. XML schema validation can also
be performed on the input pureQueryXML files.