Archives of the TeradataForum

Message Posted: Tue, 09 Dec 2008 @ 19:30:18 GMT

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

<-- Anonymously Posted: Tue, 9 Dec 2008 12:59 -->

An IMPORT MLOAD must always qualify by the (entire) primary index, for any DML statement applied.

But a DELETE MLOAD must not specify the PI. That's a special case where the DML must be a single DELETE for a single table. Try the subselect with that...

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