EXAplus Commands

The following table provides an overview of the available commands in EXAplus CLI. Click on the commands for more details.

Command Function
File and Operating System Commands
@ and START Loads a text file and executes the statements contained therein.
@@ Loads a text file and executes the statements contained therein. However, if this statement is used in a SQL script, the search path begins in the folder in which the SQL script is located.
HOST Performs an operating system command and then returns to EXAplus.
SET SPOOL ROW SEPARATOR Defines the row separator for the SPOOL command.
SPOOL Saves the input and output in EXAplus to a file.
Controlling EXAplus
BATCH Switches batch mode on or off.
CONNECT Establishes a new connection with Exasol.
DISCONNECT Disconnects the current connection with the database.
EXIT and QUIT Terminates all open connections and closes EXAplus.
PAUSE Issues some text in the console and waits for confirmation.
PROMPT Issues some text in the console.
SET AUTOCOMMIT Controls whether Exasol should automatically perform COMMIT statements.
SET AUTOCOMPLETION Switches auto-completion on or off.
SHOW Displays EXAplus settings.
TIMING Controls the built-in timer.
WHENEVER Defines the behavior of EXAplus in the event of errors.
COLUMN Shows the formatting settings or amends them.
SET COLSEPARATOR Sets the string that separates two columns.
SET ENCODING Selects a character set or outputs the current one.
SET ESCAPE Sets the escape character, which makes it possible to input special characters.
SET FEEDBACK Controls the output of confirmations.
SET HEADING Switches the output of column headings on or off.
SET LINESIZE Sets width of the output lines.
SET NULL Defines the string for displaying NULL values in tables.
SET NUMFORMAT Sets the formatting of numeric columns in tables.
SET PAGESIZE Sets how many lines of text there should be before column headings are repeated.
SET TIME Switches output of the current time of the client system at the input prompt on or off.
SET TIMING Switches display of the time needed for execution of an SQL statement on or off.
SET TRUNCATE HEADING Defines whether column headings are truncated or not.
SET VERBOSE Switches additional program information on or off.
Statements for handling variables

The user can define any number of variables, which remain effective for the duration of the EXAplus session or until explicitly deleted with an appropriate statement. The value of a variable can be accessed in all statements with &variable. Variables are always treated as strings.

ACCEPT Receives input from the user.
DEFINE Assigns a value to a variable.
SET DEFINE Sets the characters with which the user variables are initiated.
UNDEFINE Deletes a variable.