Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2005 @ 18:57:04 GMT

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

Subj:   Re: Restrict number of Rows Affected
From:   Koripally, Sridhar


I do not see anything like this in teradata. But, you can achieve this (without fear of rollbacks) by using Multiload for delete. Even if there is restart Mload will take care of using its own logtable. Another best way, which you know, is to use

--insert select to put all rows except rows to be deleted into temp table.

--Then delete/drop Original table.

--Rename Temp table.


Sridhar Koripally
Certified Teradata Master (v2r5)

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