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.
No 'On Update' feature in TD (it seems more appropriate for OLTP's, not DW's) You may use a TRIGGER instead.