How to Use the > or >> Characters to Specify Output Files | Basic Teradata Query - 17.00 - Using the > or >> Characters to Specify Output Files - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

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, see Using Scripts, Run Files, Macros, and Stored Procedures.