Mload delete task - where does the 1 row from source be stored

Tools
Enthusiast

Mload delete task - where does the 1 row from source be stored

Greetings Experts,

The DELETE task in Mload doesn't have a acquisition phase.  Now, when I specify the an input file with only one record (as supported by delete task) as follows.

.LOGTABLE Ordr_Log;
.LOGON TeraQA/SQL01,SQL01;
.BEGIN DELETE MLOAD
TABLE Order_Table;

.LAYOUT inlayout
.FIELD ordrdate * DATE;

DELETE FROM Order_Table where Order_date <= :ordrdate;

.IMPORT INFILE
LAYOUT inlayout;
.END MLOAD;
.LOGOFF;

Now where does the value for the ordrdate column specified in FIELD is stored and transferred to Teradata?

Tags (2)
1 REPLY
Teradata Employee

Re: Mload delete task - where does the 1 row from source be stored

In the .IMPORT command you specify the file name after the "INFILE" keyword.

-- SteveF