Page History

NAME
      cli - Command line interface configuration tool

SYNOPSIS
      cli

DESCRIPTION
      Command line interface configuration tool allowing the user to quickly change the behavior of the command line interface between 'fluid', 'shell' and 'SQL modes. If mode is not 
      specified, the current mode remains unchanged.

      SQL Mode
      The SQL mode assumes everything typed within it is an SQL statement and places all content in the sqlbuffer. It will send queries to a connected server when it encounters a
      trailing / or @.
      It will also send statements to the server If it encounters a carriage return and then go or GO. Its prompt displays the current database username and registered server
 name from its 
  server name from its connection properties and sequentially numbers lines with each carriage return until a statement or FluidShell command is executed. When a statement 
      executes the sequential numbering next to 
      the prompt resets to 1. SQL mode will evaluate a line to be a comment with a leading # that is not followed by a character that is a 
      letter or digit. This allows the use of # to handle temp 
      table references like #temptable.

...

      Shell Mode
      The shell mode operates like a standard operating system shell and does not require the use of a preceding \ for FluidShell commands. Its prompt is the current operating system
      user and working directory appended 
      with a $

      To send SQL statements to a connected server requires those statements to be preceded by a ; The shell mode will evaluate a line to be a comment with a leading #.

...

Fluid Mode
      The fluid mode operates like a standard operating system shell, but it also understands SQL statements explicitly. Its prompt is the current working directory appended with a $ 
      followed by : and a line number based on what 
      is stored in the SQL buffer.

...