Aborting a File Redirection

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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.