Archives of the TeradataForum

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

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

<-- 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>>