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
Aqua Data Studio / nhilam |
Follow
827
|
| declare | |
| declares a variable. | |
| Synopsis | |
\declare [-x] [name=value] |
|
| Description | |
|
Declare variables and/or give them attributes. If no NAMEs are given then display the values of variables. The -p option will display the attributes and values of each NAME. When -p is used with NAME arguments, additional options are ignored. When -p is supplied without NAME arguments, it will display the attributes and values of all variables having the attributes specified by the additional options. If no other options are supplied with -p, declare will display the attributes and values of all shell variables. Please refer to the Variables section for the list of pre-set variables. |
|
| Options | |
|
-p VARIABLE Prints the value of a variable. |
|
| Examples | |
|
Let us first declare a variable using the \declare command \declare myvar="This is FluidShell" |
|
|
To change the default prompt in FluidShell, use the below command: \declare prompt=$ |
|
|
To enable variable substitution in SQL statements, use the following command: \declare sql_variable=1 |
|
|
To declare the number of statements to be kept in memory: \declare histsize=250 |
|
|
To declare the number of result declares returned by a query: \declare max_rows=100 |
|
|
To display the SQL Statements in the console, when queries are executed, use the command: \declare options.console.show.sql=true |
|
|
To display column headers with SQL results: \declare options.console.show.columnheaders=true |
|
|
To declare the SQL results to be displayed as Form Results: \declare options.console.show.resultasform=true |
|
|
To declare the Margin character length with SQL results: \declare options.console.show.margincharlength=5 |
|
|
To display warnings with SQL queries: \declare options.console.show.warnings=true |
|
|
To display warnings headers with SQl queries: \declare options.console.show.warningheaders=true |
|
| See Also | |
| unset |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017