Archives of the TeradataForum

Message Posted: Thu, 26 May 2005 @ 12:41:05 GMT

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

Hi,

To correct this you need to change the WHERE clause.

If column empno is the primary index then your original select will be a single-amp query, lovely and fast, but not what you use Fastexport for.

If you simply want to see fastexport run then change the WHERE clause to one of the following:

     where empno <> '7839';

OR

     where empno < '7839';

OR

...almost anything that is valid SQL syntax apart from what you started with.

Cheers,

Dave

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