Online Documentation for SQL Query for DB2

Executing queries


When all the query parameters are set, you can immediately execute the query in SQL Editor.

 

To execute a query, select the Query | Execute main menu item, or use the iconExecuteQuery Execute query button on the main toolbar. You can also use the F9 hot key for the same purpose.

 

hs3315 - Executing queries

 

If the SQL syntax is correct, the query is executed and, in case the query statement is supposed to return data (e.g. as SELECT statement), the Results area containing the returned data appears within the Data tab. The position of the tab depends on the Query results on separate tab option selection (see Environment options | Preferences). If SQL syntax of the query contains any errors, the query execution is stopped and the corresponding error message is displayed in the status bar area at the bottom of the editor window.

 

By default, data returned by a query are displayed as a grid (see Data View for details).