Working with Scripts and Files

Go Up to Session 2: Productivity Enhancers

Rapid SQL extends the auto-generation of SQL code by allowing you to run your scripts across multiple databases at the same time.

File Execution Facility

Files containing SQL scripts can be added to the File Execution Facility and executed immediately or scheduled to run later.

1. On the Tools menu, select File Execution Facility. Rapid SQL opens the File Execution Facility dialog box.
2. To locate the file, you want to execute, click Add. Use the Add Files dialog box to locate and select a file.
3. On the Target tab, select the datasources to run the script against.
4. On the Output tab, select the desired output option. For the purposes of this example, select Graphical Output.

   Note: To enable the scheduling function for the script, you must select the File Output option.

5. If you want to send notification that the script has executed, on the Notify tab, complete the target information.
6. Click Execute if you want Rapid SQL to run the script against the target datasources. Otherwise, close the dialog without executing.

   Note: Separate script output windows are created for each selected datasource.

Script Execution Facility

The Tools menu also offers a Script Execution Facility. Similar to the File Execution facility, it lets you type or paste the script to be executed.

Proceed to Viewing Data.