Archives of the TeradataForum
Message Posted: Thu, 15 Jul 1999 @ 17:13:46 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|