Purpose
Limits BTEQ output to errors and request processing statistics. The less verbose format can significantly decrease the size of the generated standard output. It may also decrease the overall time it takes BTEQ to generate final results.
Syntax
Usage Notes
When the QUIET command option is set to ON, BTEQ suppresses the following:
For example:
*** Ok, Session 31587, Request 1, Statement# 1
*** Success, Stmt# 1 ActivityCount = 1
*** Success, Session 31587, Request 2, Stmt# 1 ActivityCount = 1
Mainframe BTEQ never suppresses ActivityCount messages. Workstation BTEQ suppresses ActivityCount messages only when single-session is used.
For example:
*** Query completed. One row found. One column returned.
*** Insert completed. One row added.
BTEQ suppresses ActivityType messages if exporting in Field Mode. If not exporting in Field Mode, BTEQ suppresses ActivityType messages only when single-session is used.
BTEQ does not suppress generation of the time-taken messages or of error messages.
If QUIET ON is used with the REPEAT or = command, BTEQ determines the reporting of time statistics by the number of sessions being run. With multiple sessions, BTEQ only reports the summary times for each cycle (start time, finish time, and total time). During a single session, BTEQ reports summary and processing times of queries executed in each cycle.
Typically, the QUIET and REPEAT commands are used together in multi-session data-load operations.
When using QUIET ON ALL, BTEQ will suppress even more output including:
*** Starting Row 0 at Tue Jul 10 14:58:21 2012
*** Growing buffer to 65473
*** Total elapsed time was 1 second.
Using QUIET OFF or QUIET OFF ALL has the same effect of turning the setting completely off.
If the QUIET command is not specified, the value is OFF by default. If the command is used and ON or OFF is not specified, BTEQ sets QUIET to ON.
The QUIET command can be used in a Teradata SQL macro.
Example
To limit BTEQ to a moderate amount of output, type:
.SET QUIET ON
Example
To suppress the greatest amount of BTEQ output, type:
.SET QUIET ON ALL
Example
The Example 1 QUIET command in a Teradata SQL macro appears as:
ECHO '.SET QUIET ON';