REPLACE = {Y | N};
If REPLACE is set to N and the destination file exists, the data is appended to the end of the file. If REPLACE is set to Y, the data in the target file will be replaced. This statement is supported for the following formats: Free ASCII, Fixed ASCII, and SQL. With all other formats, the file is replaced instead of being appended to regardless of how REPLACE is set.