Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 25 Jan 2011 @ 12:42:05 GMT


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


Subj:   Cascading Master Detail Deletes
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, January 25, 2011 05:17 -->

Hi Everyone,

I have a file containing duplicate and records marked for deletion. I want to read the file and perform the following funtions in one script.

1. Insert the records into log table.

2. Pass the tablename as parameter

3. Evaluate the child tables of the provided master table 4. Delete from the Master table as well as the Detail table (after evaluting the detail tables of the master)


Can anyone suggest me the solution or help me toward achieving it.


Thanks & Regards



     
  <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: 27 Dec 2016