Archives of the TeradataForum

Message Posted: Thu, 25 Aug 2005 @ 17:10:24 GMT

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

Hi Manoj,

You can specify one attribute to contain the value of the updation timestamp.

Whenever you are trying to add a row you can enter the value of the systime in that column

At time of updation you can create one table which keep track of the last update for tables values.

Using that date you can update the rows in the existing table.

For eg;

     select  a.first name
     from student a,
     last_updated_table b
     where a.change date >b.last_updated_date

Regards,

Ghanshyam Das Varindani

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