Creating a pureQueryXML file from an SQL script file with the workbench

You can create a pureQueryXML file from a SQL script file that contains SQL statements and cursor attribute information.

Before you begin

The SQL script file is in a project with pureQuery enabled. For information about the format of a SQL script file, see Format of the SQL script file used by the GeneratePureQueryXml utility.

To create a SQL script file from a Java source file, see Extracting SQL statements from a Java source file with the workbench.

About this task

The pureQueryXML file that is created from an SQL script file will not have the same SQL-related information as a pureQueryXML file that is created by capturing SQL statements from an application. For information about using the pureQueryXML file created from a SQL script file, see GeneratePureQueryXml utility.

Procedure

To create a pureQueryXML file from an SQL script file:

  1. From your project, open the SQL script file in the SQL Editor. Add or update the cursor attribute information in the file if needed.
  2. From the SQL Editor pop-up menu, click Generate pureQueryXML. The wizard starts to create a pureQueryXML file.
  3. Update the information as needed and complete the wizard.

Results

A pureQueryXML file is created.


Feedback