Archives of the TeradataForum

Message Posted: Thu, 23 Jun 2011 @ 18:11:49 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>