Diagnostic Controls - Basic Teradata Query

Basic Teradata Query Reference

Basic Teradata Query
Release Number
October 2018
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

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.