The following commands control the triggering of a variety of diagnostic aids that take shape either as informational messages included in its output stream or the invocation of external processes used for response activity event notification and logging. The commands that trigger informational messages cover custom messages, command set syntax, controls' current state, reflection of meta results for recent instructions and component version listing for product serviceability.
| BTEQ Command | Function |
|---|---|
| ECHOREQ | This control enables users to specify if a copy of the Teradata SQL requests and BTEQ commands should be placed in the standard output stream. |
| HELP BTEQ | Returns a list of all available BTEQ commands and non-graphic representations of their syntax. When a BTEQ command is specified, an individual syntax and purpose statement are displayed. |
| NOTIFY | This control enables users to specify a user exit or pre-defined action when certain significant events occur. NOTIFY applies only to the SQL request that immediately follows it. |
| QUIET | This control enables users to specify whether BTEQ output is limited to errors and request processing statistics. This may significantly decrease the amount of output and hence improve the overall response time. |
| REMARK | Prints the specified string to the standard output stream. |
| SHOW | Prints the last SQL request sent to the database to the standard output stream. |
| SHOW CONTROLS | Prints current values for one or all BTEQ settings to the standard output stream. |
| SHOW ERRORMAP | Lists BTEQ's severity levels currently mapped for database errors and warning codes. |
| SHOW VERSIONS | Lists version levels for BTEQ and the key Teradata software it depends on. |
| TIMEMSG | This control enables users to specify whether any elapsed or total query time messages are to be printed. |
| TMSMMSG | This control enables users to specify whether to print diagnostic messages that describe loggable TMSM events. |