Automatic date time updation

ratheeshknair · #1 (**permalink**) 12-02-09, 02:14

HI Experts,

I want to have a column which can track the changes in a particular row..How can i achieve the same ?which datatype to use?

TIA

sathyaram_s · #2 (**permalink**) 12-02-09, 04:27

what db2 version and platform are you on ?

ratheeshknair · #3 (**permalink**) 12-02-09, 05:49

DB2 9.5c Express

Windows XP Professional

sathyaram_s · #4 (**permalink**) 12-02-09, 08:16

Code:

CREATE TABLE TABLENAME1 (
COL1 INT, 
COL2 INT, 
LAST_UPDATE_TS TIMESTAMP NOT NULL GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP
)

does this help?

ratheeshknair · #5 (**permalink**) 12-07-09, 05:38

Thanks Satya it worked...:-)

ratheeshknair · #6 (**permalink**) 12-07-09, 06:09

By the way is there any constraint to achieve the same?

How can i alter a column to include this change?

sathyaram_s · #7 (**permalink**) 12-07-09, 07:06

ALTER TABLE Statement ?

IIRC, you have to issue a SET INTEGRITY Statement following this alter