Archives of the TeradataForum
Message Posted: Thu, 15 Jul 1999 @ 17:13:46 GMT
| Subj: | | Re: MLOAD DELETE problem |
| |
| From: | | Steve Bracewell |
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
| 
