ASA Getting Started
Introduction to Adaptive Server Anywhere
Adaptive Server Anywhere applications
Interactive SQL is an application for typing and sending SQL statements to a database. Interactive SQL allows you to query and alter data in your database, as well as modify the structure of your database.
Everything that can be done in Sybase Central can be done in Interactive SQL, but administration tasks are easier in Sybase Central. For this reason, this book uses Sybase Central whenever possible, but when a task is important, or is simple to accomplish in Interactive SQL, the Interactive SQL instructions are also included.
For an introduction to Interactive SQL, see Using Interactive SQL.
The SQL Statements pane This is where you type SQL statements to access and modify your data. The title bar above the SQL Statements pane displays the current connection information.
The Results pane This is a tabbed pane that displays query result sets, messages from the database server, and information about query execution. For example, if you enter a query asking how many customers ordered five or more different types of products, that number appears on the Results tab in the Results pane, and the query optimizer's plan for executing the statement appears on the Plan tab in the Results 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.