Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023