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.
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:
- 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.
- Click Update working copy of pureQueryXML to
expand the update section.
- 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.
- 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.
- 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.