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.