Execute the SQL
file using one of the following methods.
| Option |
Description |
|---|
| From SQL File Editor |
- Open the SQL file from the WorkSpace Navigator project folder in
which it is stored by right-clicking the file and choosing
.
- Right-click in the editor, and select
Execute All.
Note: If the SQL file is not connected to the connection
profile with which it is associated,
Execute All is disabled.
|
| From WorkSpace Navigator
|
Right-click the
file in WorkSpace Navigator, and choose
Execute SQL File.
|
| From the toolbar |
- Click the
Choose a SQL File to Execute
icon on the Database
Development perspective toolbar.
- Select the SQL
file you want to execute from the file system, and click
Open.
- (Optional) If you
did not create a connection profile for this database type, click
Create.
- Choose the
Connection Profile Type,
Connection Profile Name, and
Database Name.
- Click
OK.
|
The SQL file executes, and results appear in the SQL Results view.
SQL Results view
displays the result sets, database server messages,
execution status (success or failure) and operation details.