/*****************************************************************/ /* This task will delete all employees with less than */ /* 5 years experience from the employee table. */ /*****************************************************************/ .Logtable Logtable001; /* Logon to Teradata Database &*/ .Logon tdpx/user,pwd; /* identify the restart table */ .Begin Delete Mload /* Specifydelete task and */ Tables Employee; /* identify target table */ Delete From Employee /* The delete statement drops */ Where YrsExp < 5; /* employees with <5 yrs exp. */ .End Mload; /* Initiate MLOAD processing */ .Logoff; /* Logoff Teradata Database */