Sending commands to the database

Once you are connected to the database, you can send commands to it. For example, type the following line in the SQL Statements window.

SELECT * FROM SalesOrders

Click the right-facing triangle button on the Toolbar or press F9 to execute the query. The SQL statement displays all (*) the columns from the SalesOrders table.

Shown is the Interactive sequel window with two panes. The top pane, sequel statements, contains the text select asterisk from employees; The bottom pane, results, displays the values of each row of columns in the table, sorted by row ID in descending order. Below the results are tabs for Messages and Plan and the row count 75 rows

For more details about executing SQL statements, see Chapter 2, “Using Interactive SQL (dbisql),” Using Interactive SQL (dbisql) in the Utility Guide.