ASA Getting Started
Using Interactive SQL
Starting Interactive SQL
Interactive SQL has the following panes:
SQL Statements Provides a place for you to type SQL statements.
Results Displays the results of commands that you execute. For example, if you use SQL statements to search for specific data in the database, the Results tab in this pane displays the columns and rows that match the search criteria. If the information exceeds the size of the pane, scroll bars automatically appear for the pane. You can edit the result set on the Results tab.
For more information about editing the result set, see Editing table values in Interactive SQL.
The Messages tab displays messages from the database server about the SQL statements that you execute in Interactive SQL.
The Plan tab and the UltraLite Plan tab in the Results pane display the query optimizer's execution plan for a SQL statement.
You can set options for the tabs and panes in the main Interactive SQL window from the Options dialog found in the Tools menu.
The title bar at the top of the window displays connection information, as follows:
database-name ( userid ) on server-name
For example, if you connect to the sample database using the ASA 9.0 Sample ODBC data source, the title bar is as follows:
asademo ( dba ) on asademo9