Specifying a Standard Output File - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
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:

 

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.

Using the > or >> Characters

Use the > and >> characters to specify output files as follows:

 

Redirection Operator

Filename State

Results

> (single character)

New

The new file is created as the standard output file.

> (single character)

Existing

The existing file is overwritten with new records.

>> (double characters)

New

The new file is created as the standard output file.

>> (double characters)

Existing

The new records are added to the end of the existing file.

For more information and examples of specifying a standard output file, refer to “Using Scripts, Run Files, Macros, and Stored Procedures” on page 65.

Specifying Output File Block Size

When defining output files, specify a BLKSIZE that is large enough to accommodate the expected results.

 

Job Type

Block Size

Single interactive mode session

1024K

Single-session batch job

1024K

Large, multi-session job

4096K

Specifying Output File Logical Record Length

LRECL specifications for output files must indicate the appropriate record length, plus five additional bytes:

  • One byte for carriage control character
  • Four bytes to accommodate variable format
  • Note: Carriage control for exported REPORT and DIFformat files is not supported for Unicode® when using z/OS BTEQ.