 |
 |
Archives of the TeradataForum
Message Posted: Thu, 23 Jun 2011 @ 18:11:49 GMT
Subj: | | Re: Work table during Multi load update and delete |
|
From: | | Barry Hull |
I think that I was wrong on the work table for the DELETE task. It does look like it has a work table as well, but it probably just contains a
row if you are using a parameter as part of your DELETE statement. So, for instance, if you are reading a file to bring in a "purge date", the
work table would probably contain the purge date itself and you would code something like this:
DELETE FROM mytable
WHERE INSERTION_DATE <= :purge_date;
Hope that helps.
Thanks,
Barry
| |