Merging pureQueryXML files without specifying a base file

You can merge two or more pureQueryXML files without specifying any of them as a base file.

About this task

In the file that results from the merge, the Merge utility combines the SQL statements from all of the pureQueryXML files into a single, unnamed statement set.

Note: The first file in the list of merged files is treated as the base file for the merge. The first file cannot be a pureQueryXML file that was created to capture additional SQL statements when both the outputPureQueryXml and the pureQueryXML properties were specified. When both properties are specified, the outputPureQueryXml contains captured SQL statements that do not appear in the pureQueryXML file that is specified by the pureQueryXML property.

Procedure

To merge pureQueryXML files without specifying a base file:

  1. In the Project Explorer, select the group of files that you want to merge together. All of the files can be open for editing, provided that the most recent changes in them are saved.

    The workbench expects all of the files to be in the same folder, whether a folder in your Java™ project or a folder elsewhere on the file system.

  2. Right-click the selection and then select Merge.
  3. In the Save window, specify both the location in which you want to save the new file and a name for the file.
  4. Click Save.

    The editor creates the file. If the file is in the pureQueryFolder folder of your Java project, move the original pureQueryXML files out of that folder and then refresh the SQL Outline view. SQL statements that appear in the original pureQueryXML files and in the file that results from the merge process appear only once in the SQL Outline view. Therefore, if you keep the original files and the resulting file together in the pureQueryFolder folder, you cannot know which instance of an SQL statement you are working with in the SQL Outline view.


Feedback