dbisql Interactive SQL Utility

Interactive SQL (dbisql) is a graphical utility included with SAP Sybase IQ that lets you execute SQL statements, build scripts, and display database data.

• Starting Interactive SQL from the Windows Start Menu
  Start Interactive SQL from the Windows Start menu.
• Starting Interactive SQL from a Command Prompt
  Start Interactive SQL from the command prompt on Windows or UNIX.
• Interactive SQL Utility Syntax
  Invoke Interactive SQL from a command prompt.
• Interactive SQL Command Line Options
  Specify options when invoking Interactive SQL from a command prompt.
• Interactive SQL Connection Parameters
  When no database is connected, SAP Sybase IQ displays the Connect window to request connection parameters. Information you enter in the Connect window is not preserved between sessions.
• Execute SQL Statements and Command Files
  After you execute a SELECT statement, the result set appears on the Results tab in the Results pane. By default, row numbers appear to the left of the result set.
• Result Sets
  Work with the results of commands that you execute.
• Favorites List
  You can add the current database connection and open SQL file to your Favorites list.
• Command Recall
  When you execute a command, Interactive SQL automatically saves it in a history list that persists between Interactive SQL sessions. You can also log your executed commands to a log file.
• Build Queries with the Query Editor
  The Query Editor is a tool in Interactive SQL that helps you build SELECT statements.
• View Plans Using the Interactive SQL Plan Viewer
  The Plan Viewer is a graphical tool for viewing graphical plans for databases.
• Source Control Integration
  Interactive SQL integrates with third-party source control systems, allowing you to perform many common source control operations on files from within Interactive SQL.
• SQL Statements for Interactive SQL
  Interactive SQL statements can only be used from within Interactive SQL.
• SQL Options for Interactive SQL
  Interactive SQL options are a subset of the SAP Sybase IQ SQL options. These change how Interactive SQL interacts with the database.