Triple-Break - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-02-20
dita:mapPath
kil1527114222313.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Enter a third break to terminate BTEQ. Alternatively, entering either EXIT or QUIT after the first break also terminates BTEQ.

The behavior above is for console BTEQ only. Interrupt and Abort functions are available in BTEQWIN on the Sessions menu; CTRL+C is undefined in BTEQWIN.

Triple-breaks can be used to end batch more or interactive mode BTEQ execution. However, for BTEQ to recognize a triple-break scenario, the breaks (pressing CTRL+C key) need to happen fairly quickly, or else BTEQ may recognizing them as single breaks. So, pressing and holding down CTRL+C can be used to effectively simulate the triple-break scenario.