Archives of the TeradataForum

Message Posted: Thu, 04 Nov 2004 @ 17:25:09 GMT

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

AKleema

I believe your instinct is correct - MLoad delete will not work with a subselect or a join.

If you have known predicates such as :

     WHERE employee_last_name like 'WOL%';

it works. You may also accept in a parameters from a file.

Hope this helps

Frank

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