OUTPUT

Core command

In a Script, hides routine output (QUIET) or shows it again (NORMAL, the default)

Arguments

QUIET | NORMAL (mandatory)

Examples

OUTPUT QUIET;
OUTPUT NORMAL;

Notes

Hides or shows the routine output of a Script: OUTPUT QUIET or OUTPUT NORMAL.

Allowed in Scripts only. Every Script run starts in NORMAL. QUIET hides the statement echo, the Found N queries line, the variable value lines, the row counts of inserts, updates and deletes, the blank separator lines, the LET confirmations, and the final status line when the status is SUCCESS. It never hides query results, ECHO messages, SHOW SCRIPT VARIABLES, the output of other commands, warnings, errors, or a final status other than SUCCESS.

The setting lasts until the end of the Script or the next OUTPUT statement; a Script it calls starts with the same setting. The activity log always receives everything, including the hidden lines.

See Controlling output in the SQL scripting guide.

Last modified in release 5.3.3.