Extracting SQL statements from a Java source file with the workbench

Create an SQL script file that contains SQL statements from the Java™ file.

Before you begin

The Java file is in a project with pureQuery enabled.

Procedure

To extract SQL statements from a Java source file:

  1. Open the SQL Outline view and select the Java page.
  2. Right-click a Java source file, then click Export SQL to File. A SQL script file that contains the SQL for the Java source file is created.
  3. Optional: In the SQL editor, update the SQL script file with comments and cursor attribute parameters for the SQL statements. For information about the format of a SQL script file, see Format of the SQL script file used by the GeneratePureQueryXml utility.

What to do next

With the workbench, you can merge the data in the SQL script to a runtime group version, or you can create or update a pureQueryXML file with information from the SQL script file.


Feedback