Using Interactive SQL in Graphics Mode

Interactive SQL is the GUI-based isql utility, and allows you to execute SQL statements, build scripts, and display database data to the server..

In addition, Interactive SQL can run command files or script files. For example, you can build repeatable scripts to run against a database and then use Interactive SQL to execute these scripts as batches.

• Starting Interactive SQL
  The menu item Open Interactive SQL opens a connection to a server. However, when you select the menu item for a server, Interactive SQL opens a connection to the default database for that server. When you select a specific database from the Open Interactive SQL menu, Interactive SQL opens to the selected database.
• The Main Interactive SQL Window
  The Interactive SQL window includes four panes.
• The Interactive SQL Toolbar
  The Interactive SQL toolbar appears at the top of the Interactive SQL window.
• Open Multiple Windows
  You can open multiple Interactive SQL windows. Each window corresponds to a separate connection.
• Keyboard Shortcuts
  Interactive SQL provides keyboard shortcuts.
• Display Data Using Interactive SQL
  Interactive SQL allows you to browse the information in databases.
• Edit Table Values in Interactive SQL
  Once you execute a query in Interactive SQL, you can edit the result set to modify the database. You can also select rows from the result set and copy them for use in other applications. Interactive SQL supports editing, inserting, and deleting rows. These actions have the same result as executing update, insert, and delete statements.
• SQL Statements in Interactive SQL
  You can enter all SQL statements as commands in the top pane of the Interactive SQL window. When you are finished typing, execute the statement to run it.
• Configure Interactive SQL
  You can configure Interactive SQL in the Options dialog, which provides settings for commands, appearance, import/export features, and messages.
• Processing Command Files
  This section describes how to process files consisting of a set of commands.
• The SQL Escape Syntax in Interactive SQL
  Interactive SQL supports JDBC escape syntax, which allows you to call stored procedures from Interactive SQL regardless of the database management system you are using.
• Interactive SQL Commands
  Interactive SQL includes a set of commands that are entered in the top pane of the Interactive SQL display. These commands are intended only for Interactive SQL and are not sent to the SAP ASE server for execution.