Chapter 2: Interactive SQL Commands

This chapter describes Interactive SQL commands. These commands are entered in top pane of the Interactive SQL display. These commands are intended only for Interactive SQL and are not sent to Adaptive Server for execution. For information about Interactive SQL, see Chapter 9, “Using Interactive SQL” in the Utility Guide, and the Adaptive Server Plug-in online help.

**Table 2-1: DBISQL commands**
Command	Description
clear	Clears the Interactive SQL panes.
configure	Opens the Interactive SQL Options dialog.
connect	Establishes a connection to a database.
disconnect	Drops the current connection to a database.
exit	Leaves Interactive SQL.
input	Imports data into a database table from an external file or from the keyboard.
output	Imports data into a database table from an external file or from the keyboard.
parameters	Specifies parameters to an Interactive SQL command file.
read	Reads Interactive SQL statements from a file.
set connection	Changes the current database connection to another server.
set option	Use this statement to change the values of Interactive SQL options.
start logging	Use this statement to start logging executed SQL statements to a log file.
stop logging	Use this statement to stop logging of SQL statements in the current session.
system	Use this statement to launch an executable file from within Interactive SQL.