cli (Revision #8)

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

sa:[SQL Server 2012 - 80]:1> select top 3 * from Orders
sa:[SQL Server 2012 - 80]:2> go >>exported_data.csv

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 it requires those statements to be preceded by a ; The shell mode will evaluate a line to be a comment with a leading #.

Administrator:C:\Documents and Settings\Administrator$ ;select top 3 * from Orders
Administrator:C:\Documents and Settings\Administrator$ go >>exported_data.csv

Fluid Mode
The fluid mode operates like a standard operating system shell, but it also understands sql statements explicitly. Its prompt is the current operating system user and working directory appended with a $

Administrator:C:\Documents and Settings\Administrator$ select top 3 * from Orders
Administrator:C:\Documents and Settings\Administrator$ go >>exported_data.csv

OPTIONS

sql
Change the command line interface behavior to [sql] mode.

shell
Change the command line interface behavior to [shell] mode.

fluid
Change the command line interface behavior to [fluid] mode.

-es
Defines the character used to indicate an explicit SQL buffer request.

-ec
Defines the character used to indicate an explicit shell command request.

-fs
Indicates whether a [/] character at the end of a line will trigger a SQL buffer execution.

-as
Indicates whether a [@] character at the end of a line will trigger a SQL buffer execution.

-ss
Indicates whether a [;] character at the end of a line will trigger a SQL buffer execution.

-ae
Indicates whether alias expansion is to be performed.

-vc
Indicates whether a leading [#] is evaluated as a comment line.

-vh
Indicates whether history command expansion is to be performed.

-ves
Indicates whether an explicit SQL character is to be evaluated to determine a SQL buffer request.

-vec
Indicates whether an explicit shell command character is to be evaluated to determine a shell command request.

-enf
Indicates whether an explicit shell command request for an unknown command creates a shell exception.

-vic
Indicates whether an implicit shell command request is to be evaluated.

-ib
Indicates the implied request in case no other evaluation has been sucessful. { sql, error }

-p
Sets the PROMPT variable.

See the CLI section of Common Aliases and Variables page for more on how to alter the modes. Executing the export command will display all of the settings for your current mode.

EXAMPLE

To use the sql mode:

cli sql

To use the shell mode:

cli shell

To use the fluid mode:

cli fluid

Search Tips

Aqua Data Studio / nhilam

cli (Revision #8)

Search Tips

Aqua Data Studio / nhilam

Title

cli (Revision #8)