On Update Current_TimeStamp

Database
SHF
N/A

On Update Current_TimeStamp

The customer is asking if there is a feature like 'On Update'  ( as in SQL Server) to update the Current Timestamp in a table in Teradata?

The customer is currently on 12.03 release.

Table Definition example: columns (IDtype, Name, Current_TimeStamp)

If they update the Name, they want the Current_Timestamp to be updated automatically, without having to specify it in the Update statement.

Thanks in advance.

3 REPLIES

Re: On Update Current_TimeStamp

No 'On Update' feature in TD (it seems more appropriate for OLTP's, not DW's) You may use a TRIGGER instead.

HTH

Cheers.

Carlos.

SHF
N/A

Re: On Update Current_TimeStamp

Thank you Carlos...

Re: On Update Current_TimeStamp

How to use a trigger for on update current timestamp in Teradata?