Terminal Monitor Silent Mode
The line-based terminal monitor for SQL can be run in silent mode. Silent mode shows only query output; it suppresses header and footer text, column titles, separators, and row counts.
In addition, the terminal monitor has new commands, which include:
\[no]silent
Switches silent mode on and off.
\[no]titles
Switches column titles on and off.
\[no]trim
Trims or does not trim spaces around column data.
\vdelimiter
Specifies the vertical separator character or resets it to the default. The character can also be set to SPACE, TAB, or NONE.
This feature allows simple reports to be created as SQL scripts and then run without having to edit the output.
To start the Terminal Monitor in silent mode use the –S flag on the sql command. For example:
sql –S demodb
To invoke silent mode while in a script use \silent. For example:
sql demodb
\silent
Each command issues a confirmation message when in non-silent mode.
For details, see the Terminal Monitor appendix in the SQL Reference Guide.