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 Adaptive Server
for execution. Table 3-6 lists
the commands available for Interactive SQL.
Table 3-6: 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.
|
For more information about the Interactive SQL commands, see “Using DBISQL
Commands” in the Reference Manual: Commands.
