Overview of using the workbench to configure support for static SQL in pureQuery code

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.

Feedback