15.00 - Delete Task - MultiLoad

Teradata MultiLoad Reference

prodname
MultiLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2409-034K

Delete Task

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