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.
.BEGIN DELETE MLOAD
.FIELD ordrdate * DATE;
DELETE FROM Order_Table where Order_date <= :ordrdate;
Now where does the value for the ordrdate column specified in FIELD is stored and transferred to Teradata?
In the .IMPORT command you specify the file name after the "INFILE" keyword.