Executing SQL Statements

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > Databases and MapForce > Browsing and Querying Databases > Creating and Editing SQL Statements >

Executing SQL Statements

The SQL statements that appear in the SQL Editor can be executed against the database, with immediate effect. The result of the SQL query and the number of affected rows is displayed in the Messages pane of the DB Query pane.

 

When multiple SQL statements appear in the SQL Editor, only the selected statements will be executed. You can select individual SQL statements as follows:

 

Holding the left mouse button clicked, drag the cursor over a specific statement.
Click a line number in the SQL Editor.
Triple-click a specific statement.

 

 

To execute a SQL statement:

1.Enter or select the SQL statement in the SQL Editor (see Generating SQL Statements ).
2.Click the Execute ( ic_execute-sql ) button.

© 2019 Altova GmbH