Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Interactive SQL Online Help Interactive SQL Version 16.0

Chapter 2: Using DBISQL commands

This topic describes the commands that you can include 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 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.