declare (Revision #2)

\declare [-x] [name=value]

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