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