Specifying a Standard Error Output File - 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

By default, BTEQ writes error messages to the standard output file (STDOUT), along with the data retrieved from the Teradata Database in response to BTEQ commands and SQL requests. On Mainframe-attached systems, and some workstation-attached systems, a standard error output file (STDERR) can be specified for error messages.

For more information about specifying a standard error output file, see Error Handling and ERROROUT.

Depending on the system configuration, a standard error output file can be specified either when BTEQ is invoked or before logging on to a Teradata Database.

Use the following table to specify a standard error output file:

System Type Error Output File
Mainframe-attached Use either the BTEQ TDSBTEQ JCL procedure or a DD statement in a standard JCL file to define the ddname of SYSTERM for the STDERR device before invoking BTEQ.
Mainframe-attached Also use the BTEQ TSO command to define the ddname of SYSTERM for the STDERR device.
Workstation-attached Use the > or >> characters to define a standard error output file when BTEQ is invoked.