Executing an SQL Script

Use the Execute SQL script command from the File menu to execute an SQL script.

To execute an SQL script on a secondary RPS system

1. Select the Execute SQL script command from the File menu. The common File dialog is then displayed, with the directory defaulting to the working directory specified in the Configure RPS Node dialog.

2. Select the SQL script that you want to execute and then click the Open button. Alternatively, click the Cancel button to abandon your selections.

The connection to the RDBMS database is then established.

The execute process then executes the data script file on the target RDBMS database. The Jade RPS Manager window displays the progress of the execute process and its completion (that is, whether the script executed without error). No data is returned to JADE by the script.