The Interactive SQL window includes four panes.
The panes are:
SQL Statement – 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. You can edit the result set on the Results tab.
Messages – displays messages from the database server.
Plan – displays the query optimizer’s execution plan for a SQL statement. For more information, see “Plan dialog tab.”
The window title displays the connection name. For Adaptive Server, the connection name is either the server name (determined by the server’s interfaces file entry) or the host name and port number the user enters at the time of connection.