Archives of the TeradataForum

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

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

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