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.
Procedure
To add data from a SQL script file to a runtime group:
- Open the Common Repository Explorer view.
- 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.
- 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.
- 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.
- 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.
- Upload the pureQuery data for the runtime group version
with the editor.