削除タスク - MultiLoad

Teradata® MultiLoadリファレンス

Product
MultiLoad
Release Number
17.10
Published
2021年6月
Language
日本語
Last Update
2021-09-23
dita:mapPath
ja-JP/fel1608578437279.ditamap
dita:ditavalPath
ja-JP/fel1608578437279.ditaval
dita:id
B035-2409
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    */