Delete Task - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
fel1608578437279.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities
/*****************************************************************/
/* 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    */