Archives of the TeradataForum
Message Posted: Tue, 25 Jan 2011 @ 12:42:05 GMT
<-- Anonymously Posted: Tuesday, January 25, 2011 05:17 -->
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|