Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Jul 1999 @ 16:29:49 GMT


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


Subj:   MLOAD DELETE problem
 
From:   Stuart MacMillan

Does anyone have a suggestion for this one: we're running an MLOAD DELETE task on V2 R2.1 against a 500m row table for the first time in 15 months. It's running on good old MVS and crashes with a S0C4. This crashes on production but can't be reproduced in testing.

The DELETE task has 3 parts based on ranges of different dates which are OR'd together. There is no IMPORT statement. The delete is just a simple SQL statement

Interestingly the MLOAD manual says OR's aren't permitted in a delete statement and I should use different APPLY statements with a .DML label. (page 5-51) Another part of the manual says .DML labels aren't permitted in a DELETE task. So which is right?


thanks



     
  <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: 27 Dec 2016