Archives of the TeradataForum

Message Posted: Thu, 15 Jul 1999 @ 17:13:46 GMT

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

Mload requires the entire key on an import. You have to export the entire key of all records to be exported to a file, then mload delete using the import. You could not delete "where thedate = :importdate", rather "where thekey = :importedkey". Mload has x times the efficiencies of a bteq delete. On a 500m row table using bteq, depending on the amps, bteq delete would take 5 - 10 times longer than mload delete.

The .dml is allowed in mload delete, but has liitle value. This label is generally used to ignore or mark duplicate updated or inserted row, if upi violations would occur. You would NEED a .dml label when doing a "BEGIN IMPORT MLOAD" whereby you delete using the key.

Hope this helps and you find it correct.

Meijer ITS

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