Managing runtime group version data with the workbench

After you connect to a SQL Management repository with the Common Repository Explorer, you can use the Runtime Group Working Copy Editor to create a working copy of the pureQuery data in a runtime group version and manage the working copy of the pureQuery data.

The pureQuery data extracted from a repository runtime group version includes the pureQuery runtime properties, pureQueryXML data, configuration options, bind options, and captured SQL data. Using the editor you can view and modify the pureQueryXML data, and the options used for configuration, binding, and during runtime.

Using the editor, you can merge selected captured SQL data with the pureQueryXML data and configure the pureQueryXML data. For databases that supports static SQL, you can use the editor to modify bind properties, create packages from the SQL statements in the pureQueryXML data, and bind the packages to the database.

After you update the working copy of the pureQuery data for a runtime group version, you can update the data in the version or create a new version.

The editor supports merging selected captured SQL data, configuring the pureQueryXML data, performing a bind operation, and updating the data for the runtime group version in a single step. When the captured SQL is processed, the working version of the pureQuery configuration properties and bind properties are used. During processing, you might need to supply information needed to complete the processing.


Feedback