Informix 11 Internal timestamp column ?

[Ab Deo]

I work on a system (Informix 10) which do not maintain any programmatic date time which makes row change tracking very difficult. We have used triggers for this in past but due to performance constraints we cannot expand this solution.
We have used cdrtime in Informix 10 but as this shadow column cannot be indexed, usage of this column is limited to off business hours. We are planning to move to Informix 11. I am hoping this upgrade will provide me better solutions for row change tracking.
Any ideas ?

[BeGooden-IT Vercelletto]

Post by Ab Deo
I work on a system (Informix 10) which do not maintain any programmatic date time which makes row change tracking very difficult. We have used triggers for this in past but due to performance constraints we cannot expand this solution.
We have used cdrtime in Informix 10 but as this shadow column cannot be indexed, usage of this column is limited to off business hours. We are planning to move to Informix 11. I am hoping this upgrade will provide me better solutions for row change tracking.
Any ideas ?

Hi Ab

not sure I understand what you want to do, but aren't you wanting to do what the informix audit functionality does ?

If yes, you have it in V10, but obviously I would take a look at 11.70 or even better 12.10 which has lots of beautiful features ....

Cheers
Eric