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.