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 MLOADTABLE 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