Saving Multiple Answersets
Multiple Answersets can be saved in multiple files. The file names for two Answersets or more are created by appending a number to the original file name. For example, if you specify Result.txt, and three Answersets are returned, the file names are:
If the specified file already exists, Teradata SQL Assistant asks if you want to replace or append to the first file in the set (in the above example, Result.txt). If the first file does not exist but other files do exist, they are overwritten with no warning.