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.

The commands available for Interactive SQL are:

CommandDescription
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.

See “Using DBISQL Commands” in the Reference Manual: Commands.