Using the Break Key on Workstations - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Using the Break Key on Workstations

Use the Break key to perform the following functions:

 

Function

Result

Single-break

Interrupt BTEQ

Double-break

Abort the previous request

Triple-break

Terminate BTEQ

For more information about aborting BTEQ requests, refer to “ABORT” on page 131.

The break function has the following syntax:

where

<break> represents pressing the CTRL+C keys on your workstation keyboard.

Single-Break

The single-break function interrupts BTEQ while it is processing a previous request. BTEQ displays:

BREAK Received. Input command:

Double-Break

At the input command prompt, either press the Break key again (the double-break function), or enter CONTINUE or ABORT.

Enter CONTINUE to recover from the interrupt and resume with BTEQ as if the interrupt never occurred.

Either enter ABORT or press the Break key again to abort the previous request.

Triple Break

Enter a third break to terminate BTEQ. Alternatively, entering HX after the first break also terminates BTEQ.

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