Wiki Books
Search Tips

Easily find issues by searching: #<Issue ID>
Example: #1832

Easily find members by searching in: <username>, <first name> and <last name>.

Example: Search smith, will return results smith and adamsmith
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 827

IDE for Relational Databases

cli (Revision #4)

cli
	Command line interface configuration tool
Syntax
	\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

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017