Page History
The load editor can be run either with File > New > SQL Load or with the New SQL Load icon shown above in the red square.
...
The SQL Load Editor/Tester is accessed via the New SQL Load icon on the Toolbar:
When you open SQL Load Editor/Tester, click Select Data Source to specify the data source against which you want the SQL script to run.
...
The following configuration parameters are set with SQL Load Tester/Editor prior to executing the SQL script:
| Configuration Parameter | Description |
|---|---|
| Number of Parallel Sessions | Specifies the number of jobs that the execution script will operate on. |
| Execution End Condition | Specifies if the script execution process runs for a set amount of time or script executions. Choose Time if you want the script to execute over a specific period of time, or Number of Executions if you want the script to execute a specific number of times. |
| Sleep Between Executions | Specifies if Load Editor will wait before running the execution script again. Select the check box and choose Fixed Delay or Random Interval, depending on whether you want the script to execute at a specific time, or at random intervals within a specified range of time. |
To run Load Editor
- Access SQL Load Editor/Tester by selecting the icon on the Toolbar. The SQL Load Editor/ Tester opens.
- Click Change Data Source and choose a data source you want to run the SQL code against.
- Choose Ad hoc SQL or SQL file, and then copy/paste or manually type the code you want to execute in the window provided, or navigate to the location of the file, respectively.
- In the right-hand panel, choose the execution configuration parameters to specify how you want SQL Load Editor/Tester to handle the script.
- Click the Execute icon in the lower right-hand corner of the screen. The script starts to execute against the specified data source, using the configuration parameters you selected.
- If you are profiling a data source, start and run a new profiling session on the data source you specified in Load Editor. The session will reflect how your SQL script executes against the specified data source.