Field Specific Change Log

[Former Member]

Hi All,

Is it possible to only log the changes for specific fields of a table? My guess is this is not possible but it is suggested not to log data changes due to performance issues. If we were to limit the tables to specific fields, perhaps we can limit the affect on performance.

Also, how big of a hit on performance can we expect if we only add logging for one additional table?

Thanks. Points will be awarded for helpful responses.

[Former Member]

Hi All,

Is it possible to only log the changes for specific fields of a table? My guess is this is not possible but it is suggested not to log data changes due to performance issues. If we were to limit the tables to specific fields, perhaps we can limit the affect on performance.

Also, how big of a hit on performance can we expect if we only add logging for one additional table?

Thanks. Points will be awarded for helpful responses.

[Former Member]

Hi

Yes you can log on the field level changes.

Field level Changes (logs) are maintained in the table CDHDR and CDPOS tables

see those tables for field level changes

Reward points if useful

Regards

Anji

[Former Member]

Thanks, Anji, but I was wondering if it was possible to set specific fields. So let's say I have table ADRC and I only want to see changes to field NAME1. Can I set only this field to be logged instead of the entire table?

Message was edited by:

John S