BTEQ Error Output Files - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.00
Published
November 2016
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
hyz1479325149183.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities
In response to the BTEQ commands and Teradata SQL statements, BTEQ produces two kinds of output:
  • Error messages
  • Output data

Normally, by default, BTEQ writes both error messages and output data to the standard STDOUT file. From there, the output is directed to either the user terminal or some other device, according to the file definitions that are in effect when BTEQ is invoked.

By using the BTEQ ERROROUT command, the user can direct the error messages to some other file or device using the STDERR file. Before doing so, however, the user must define the ddname of SYSTERM for the STDERR device in the JCL before logging on to BTEQ, or by using the BTEQ TSO command.

Then, to specify a different output file for error messages, enter the ERROROUT command as follows:

.errorout stderr
*** Error messages now directed to STDERR.