Archives of the TeradataForum

Message Posted: Tue, 09 Dec 2008 @ 16:13:25 GMT

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

Good news and bad news. That worked great in SQL Assistant, but resulted in an invalid statement error (3537: A MultiLoad DELETE Statement is Invalid.) when trying to run it in an MLOAD job. Apparently MLOAD deletes can not use subselects and must key on the primary index. At least that is what I am being told by other folks here.

Oh well. I guess I am back to a multi-step process; an EXPORT followed by the MLOAD Delete.

Thanks for the help.

Bob

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