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 |
|---|---|
| COMMANDHISTORY | This helps the interactive user to display a numbered list, re-submit an item from the list, and manage the list; of previously entered BTEQ commands and SQL requests, within the same invocation. |
| ECHOREQ | This control enables users to specify if a copy of the SQL requests and BTEQ commands should be placed in the standard output stream. |
| ECHOEXPANDEDREQ | This control enables users to specify whether an expanded version of the input instruction should be printed for interactive mode, after it has been processed and acted upon, and the instruction contained any shorthand syntax. |
| HELP | 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 along with the available shorthand syntax for the command as well as its options. |
| 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. |