The Interactive SQL (dbisql) utility provides an interactive environment for database browsing and for sending SQL statements to the database server.
You can use Interactive SQL to:
Browse the information in a database.
Try out SQL statements that you plan to include in an application.
Load data into a database and carry out other administrative tasks.
In addition, Interactive SQL can run command files. You can build repeatable scripts to run against a database, then use dbisql to execute these scripts. See “Saving, loading, and running command files”.
Interactive SQL also provides feedback about the number of rows affected, the time required for each command, the execution plan of queries, and any error messages.
