Home Page for the TeradataForum

Archives of the TeradataForum

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

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

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023