17.10 - 削除タスク - MultiLoad

Teradata® MultiLoadリファレンス

Product
MultiLoad
Release Number
17.10
Release Date
2021年6月
Content Type
プログラミング リファレンス
Publication ID
B035-2409-061K-JPN
Language
日本語 (日本)
/*****************************************************************/
/* 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    */