Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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:



     .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;

Any help will be greatly appreciated!!



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