Specifying a Standard 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

A standard output file is an output file that is user-defined as the SYSPRINT file. It executes automatically in batch mode when BTEQ is invoked. If a standard output file is not specified, or if the terminal or workstation is defined as the SYSPRINT file, BTEQ displays all output reports and messages on the terminal or workstation screen.

To specify an output file do one of the following:

System Type Specification
Mainframe-attached
 Use either the BTEQ TDSBTEQ JCL procedure or a DD statement in a standard JCL file to specify the output file as the SYSPRINT file before invoking BTEQ.
Workstation-attached Use the > or >> character to specify an output file when BTEQ is invoked.