Page History
...
The following table defines pre-set variables and their function.
CONNECTIONS | Provides the directory name for "Local Database Servers" folder. |
DATABASE | Contains database name which will be used by \connect and \reconnect commands. |
DATABASEUSERNAME | This variable contains the current database user name, when connected. |
HISTCONTROL | This variable allows control over how FluidShell stores the command history. |
HISTFILE | Provides the location of the command buffer file. |
HISTFILESIZE | This variable defines the maximum number of commands that will be retained (in the physical file) by FluidShell when it exits. |
HISTSAVE | Determines whether the command history should be saved on disk or not. |
HISTSIZE | Number of lines to be kept in the command history buffer. |
HOME | Home directory of the current user. |
IS_CONNECTED | This variable stores the connection status of the FluidShell. |
LINENO | An internal variable which contains the current line number within the SQL buffer. |
MAX_ROWS | Determines the maximum number of rows returned by the \go command. |
PROMPT | Allows changing the command prompt. |
SERVERNAME | This variable contains the current connection server name, when connected. |
SHELL_VERSION | Contains the FluidShell version number. |
SQL_VARIABLES | Determines whether the variables should be expanded in SQL statements or not. |
USER | This variable contains the name of user currently logged-in (to this machine). |
USERNAME | This variable contains the current connection user name, when connected. |
CLI Settings
The following are the default settings for the Command Line Shell mode. These determine how \cli shell interprets sql statements and commands. See the \cli page for more on the three available modes ( \cli fluid, \cli shell, \cli sql). By default, the FluidShell is in \cli fluid mode.
...
Furthermore, the behavior of CLI_SHELL_LINE_INTERPRETER_EVAL_EXPLICIT_CMD and CLI_SHELL_LINE_INTERPRETER_EVAL_IMPLICIT_CMD variables is dependent on the CLI_SHELL_LINE_INTERPRETER_IMPLICIT_BEHAVIOR variable (which defines the mode in which the FluidShell interpreter is operating). The following table outlines the aforementioned behavior;
CLI...IMPLICIT_BEHAVIOR | CLI..._EVAL_EXPLICIT_CMD | CLI..._EVAL_IMPLICIT_CMD | Sample command |
sql | TRUE | TRUE |
|
sql | TRUE | FALSE |
|
sql | FALSE | TRUE |
|
sql | FALSE | FALSE |
|
shell | TRUE/FALSE | TRUE/FALSE | All commands are executed. |
SQL Results Options
You can set your preferences on how SQL results are displayed in Fluidshell using the \set command.
To display SQL Statement, use the command | \set CMD_GO_SHOW_SQL |
Display column headers | \set CMD_GO_SHOW_COLUMNHEADERS |
Display query statistics | \set CMD_GO_SHOW_QUERYSTATS |
Display warnings | \set CMD_GO_SHOW_WARNINGS |
Display warnings headers | \set CMD_GO_SHOW_WARNINGHEADERS |
Always display 'records affected' count | \set CMD_GO_SHOW_ALWAYSDISPLAYSUCCESS |
Display only the total number of affected records | \set CMD_GO_SHOW_SUM |
Margin character length | \set CMD_GO_SHOW_MARGINCHARLENGTH |
Display client statistics | \set CMD_GO_SHOW_CLIENTSTATS |
Display SQL results as form entries | \set CMD_GO_SHOW_RESULTSASFORM |
Display when execution stops on an error | \set CMD_GO_SHOW_EXEC_STOPONERROR |
Aliases
The following table lists command aliases defined in the FluidShell: