16.20 - Aborting a File Redirection - Basic Teradata Query

Basic Teradata Query Reference

Basic Teradata Query
October 2018
Programming Reference

When redirecting a standard input stream file, abort or interrupt processing on a client system using one of the following options:

  • On workstation-attached systems – use the Break key on the workstation keyboard, as described in Discarding Input and Abort Requests.
  • For UNIX and Windows systems – in response to the double-break function, BTEQ aborts the current Teradata SQL statement and continues reading the rest of the file. The triple-break function aborts the current statement and exits BTEQ.
On workstation-attached systems, do not use the single-break function to abort a file redirection operation. Pressing the Break key while a Teradata SQL statement that extends over two lines is executing, causes BTEQ to send the second line of the statement to the Teradata Database and display an error message. When using the single-break function, it must be followed with an ABORT command.