Page History

...

1. Access SQL Load Editor/Tester by selecting the icon on the Toolbar. The SQL Load Editor/ Tester opens.
2. Click Change Data Source and choose a data source you want to run the SQL code against.
3. 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.
4. In the right-hand panel, choose the execution configuration parameters to specify how you want SQL Load Editor/Tester to handle the script.
5. 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.
6. 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.