You can execute a SQL file from the SQL File Editor or from
		WorkSpace Navigator. 
  
        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.