When you use the workbench to configure support for static
SQL in pureQuery code, you can take advantage of a number of helpful
features.
- Automatic configuration of your Java projects
- After you create a Java project,
you add support for developing pureQuery code. When you add that support,
the workbench adds the required JAR files to your project's build
path. The workbench also creates the following files, or modifies
them if they already exist:
- Default.genProps
- Use this file to set the collection, root name, and version ID
for DB2® packages that you create.
If you want to bind SQL statements from more than one interface that
declares annotated methods, you can set bind options for each.
- Do not rename this file.
- Default.bindProps
- Use this file to set bind options for the packages that you specified
in the Default.genProps file. If you want to bind SQL statements from
more than one interface that declares annotated methods, you can set
bind options for each.
- Do not rename this file.
- Ease of switching connections for binding against different databases
- When you bind SQL statements, you can bind against the database
that is associated with your Java project
or against other databases.
- SQL Outline view for seeing the relationships between the objects
that you work with
- Use this view to see the relationships between your SQL statements,
the DB2 packages that the workbench
suggests or creates based on your specifications, the Java files that contain the SQL statements,
and the database objects that the statements access or refer to.
- Java editor that includes
assistance for writing and validating SQL statements
- If your project contains Java source
files, you can write and edit SQL statements by taking advantage of
the Java editor's content assistance
and SQL validation features.