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