Page History
To open a FluidShell window you click on the FluidShell button in the Server application menu or application toolbar with a key binding of Ctrl-Shift-F. When opening a FluidShell, the shell will attempt to establish a default database connection to any registered server the user may have selected in the schema browser. If no server is selected then no default database connection will be established in the newly open shell.
Once the new FluidShell is open, it will execute any initialization script. If a FluidShell is open on a specific registered server it will execute the initialization script defined in the server registration in the FluidShell tab. If a FluidShell is open without a registered server it will execute the global initialization script defined in the File > Options > FluidShell > Script. Users may configure their shells environment per registered server or at a global level by issuing any specific shell commands.
FluidShell Application Toolbar Button | FluidShell Right-click Menu | Server Properties FluidShell tab |
In the FluidShell command, prompt users may execute commands by typing the command name and hitting enter. Adding a "\" to the beginning of the command will give the shell an explicit request to execute the command line as a shell command. The first command to test is the help
command which will give you a list of commands available in the shell.
...
To learn more about each CLI shell variables visit the Shell Variable documentation: Shell Variable
The shell provides a command called cli
that makes it easier to control the behavior of the CLI. You can learn more about the command with:
...
Code Block |
---|
:$ select order_id, product_name, quantity :$ from orders :$ limit 5 :$ go order_id product_name quantity ----------- --------------- ----------- 01012007-72207-847 Aqua Data Studio v6.0 [w/ One Year Subscription] 1 01012007-72207-ROWBOAT Aqua Data Studio v6.0 [w/ One Year Subscription] 1 01012008-72207-14343 Aqua Data Studio v6.5 [w/ One Year Subscription] 1 01012008-72207-1529 Aqua Data Studio v6.5 [w/ One Year Subscription] 1 01012008-72207-BLACKDUCK Aqua Data Studio v6.5 [w/ One Year Subscription] 1 5 record(s) selected [Fetch MetaData: 1ms] [Fetch Data: 0ms] [Executed: 9/11/2012 8:45:15 AM] [Execution: 1ms |
FluidShell Query Executed | FluidShell Multiline Query |
As you work in the shell you may want to execute previously execute shell commands or SQL commands. The shell maintains a list of previously executed shell commands. The history behavior is controlled by the shell variables HIST* which can be viewed as follows:
...