Merging captured SQL and configuring pureQueryXML in a runtime group version with the workbench

You can use the Runtime Group Working Copy Editor to merge captured SQL data with pureQueryXML data and configure pureQueryXML data in a runtime group version. Merging captured SQL data and configuring the pureQueryXML data is one step in the process of managing pureQuery data for a version.

Before you begin

A repository must exist in a database and you must be connected to the database that contains the repository. For information about connecting to a repository, see Managing SQL Management repositories with the workbench

About this task

The Runtime Group Working Copy Editor extracts a working copy of the following pureQuery data to your workspace:
  • The pureQueryXML data
  • The pureQuery Runtime configuration
  • The bind options
  • The configure options
  • The captured SQL data

You use the Update the working copy of the pureQueryXML section of the editor to selected captured SQL data, merge the SQL data with the pureQueryXML data, and configure the updated pureQueryXML data.

Procedure

To merge SQL data with the pureQueryXML and configure the updated pureQueryXML data:

  1. Open the Runtime Group Working Copy Editor:
    • Right-click a runtime group, then click Manage Active Version to manage the active version for a runtime group.
    • Right-click a runtime group version, then click Manage to manage a specific version.
    The editor opens and is positioned to the Steps page. The Steps page contains instructions to manage the runtime group version.
  2. Click Update working copy of pureQueryXML to expand the update section.
  3. Select the captured SQL entries to merge into the pureQueryXML data.

    You can select the captured SQL data from the existing repository, from another repository, or from a file containing captured SQL data. To specify the captured SQL data from another location, choose Change List.

  4. Click the Configure Properties link to open a pureQuery Properties Editor. If needed, modify the options to use to configure the SQL statements in the pureQueryXML into statement sets that will be used to generate packages that will be bound as static SQL.

    For example, specify the -cleanConfigure option to apply the options to all captured SQL. If not specified, the criteria is applied to only the new statement sets that are being defined.

    Note: If the -cleanConfigure option is specified and existing statement sets will be updated, you can use the -pkgVersion = AUTO option to specify that existing packages on the database be versioned.
  5. Click Update pureQueryXML to process the selected captured SQL and the pureQueryXML data. If captured SQL data was selected, the captured SQL is merged with the pureQueryXML data. After any the merge, the pureQueryXML data is configured. Results are written to the Console view.

What to do next

Click View Change Report link to display a report of the changes to the pureQueryXML, or click the pureQueryXML link to view the updated pureQueryXML in the pureQueryXML Editor.

If the database associated with the runtime group supports static SQL, you can use the editor to create packages from the SQL statements in the runtime group version pureQueryXML data, and bind those packages to the database.


Feedback