Adding SQL data from an SQL script to a runtime group version with the workbench

When you add the SQL statements from an SQL script file to a runtime group version, the workbench generates a pureQueryXML file from the SQL script file. The pureQueryXML file can be merged with the pureQueryXML data in the runtime group 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

Procedure

To add data from a SQL script file to a runtime group:

  1. Open the Common Repository Explorer view.
  2. Right-click a runtime group or a specific version to add SQL to a runtime group version.
    • Right-click a runtime group, then click Add SQL to Active Version to add the SQL data to the group's active version.
    • Right-click a runtime group version, then click Add SQL to add the SQL data to the selected version.
    The wizard starts and will create a pureQueryXML file.
  3. Update the information as needed and complete the wizard. A pureQueryXML file is generated from the SQL script file, and the Runtime Group Working Copy Editor opens.
  4. Use the Update the working copy of the pureQueryXML section of the editor to update the pureQueryXML from the runtime group version with the new SQL statements in the pureQueryXML file.
  5. Optional: 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.
  6. Upload the pureQuery data for the runtime group version with the editor.

Feedback