Delete Task - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
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    */