Archives of the TeradataForum

Message Posted: Thu, 13 Jan 2005 @ 18:46:59 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I am not aware of any problems with the Append function. (It is more of an operating system function than an application function.)

I ran a quick test with Queryman 5.2 (which is a very old version of the product - the current version is SQL Assistant 7.0) and found the results to be correct.

My test used small data volumes (4 columns and 78, 10, 51 rows in 3 separate selects) so maybe that makes a difference. (Unlikely unless you are running on Win95/98/ME rather than NT/2000/XP.)

Note that it will add the following between each result set:

a blank line

a line of dashes

a blank line

a line containing the row headers

This might have an effect on your 'totals' if you have not edited the file to remove these lines.

I would need more information to look into this further.

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>