Running SQL statements
This SQL shell feature allows SQL statements on the database.
To use this feature, you must be connected to a database. (See ODBC Connection or JDBC Connection)
Then, from the Tools menu choose SQL Shell. Enter the SQL statement and press Enter.
There are three
options:
- Close all result: clears the information under the Result tabs. The information
under the Output tab is kept.
- Clear output: clears the information under the Output tab. The information
under the Result tabs is kept.
- Execute files: allows you to get an SQL file and to run it.