Executing a SQL File

Prerequisites 

Make sure the database server is running and you are connected to it through a connection profile.

Execute the SQL file using one of the following methods.

Option	Description
From SQL File Editor	In the WorkSpace Navigator project folder, double-click to open the SQL file in SQL File Editor. Right-click in the editor, and select Execute All.
From WorkSpace Navigator	Select one or more SQL files. Right-click the files and choose Execute SQL File. If you selected multiple SQL files, click OK in the Select Profiles for the File dialog.
From the toolbar	Click the Choose One or More SQL Files to Execute button on the Database Development perspective toolbar. On your file system, navigate to your workspace and project. Select the SQL files you want to execute from the file system, and click Open. Select the Database Server Type, Connection Profile Name, and Database Name. (Optional) If you did not create a connection profile for this database type, click Create. 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.