Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 04 Nov 2004 @ 17:10:25 GMT


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


Subj:   MLOAD DELETE gives error with sub-select.
 
From:   akleema_talukder

Hi all,

We are having a error message, when we try to delete through MLOAD and in the query we use sub-select. My question is, does MLOAD DELETE works with SUB-SELECT? If it is, then what is the probem in my script?

I am providing a sample script below:

     ROUTE MESSAGES TO FILE ${LOGDIR}/${JOBNAME}_${LOGSUF}_MLD.log;

     .LOGTABLE ${WRKDB}.LOG_${JOBNAME};

     .LOGON ${DB}/${USRID},${USRPWD};

This Works:

     .BEGIN DELETE MLOAD TABLES a285180.employees;
       DELETE FROM employees
       WHERE employee_last_name like 'WOL%';

This doesn't work:

     BEGIN DELETE MLOAD TABLES a285180.employees;
     DELETE FROM a285180.employees
       where employee_last_name in
       (select employee_last_name from a285180.employees where
     employee_last_name like 'WOL%');
     .END MLOAD;
     .LOGOFF;

Any help will be greatly appreciated!!


thanks,

AKleema



     
  <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