I have developed a program to read the DBTABLOG Table entries which keeps a Log Records of Table Changes.
On update of an entry in any table (say TCJ1T), DBTABLOG stores the entry that was updated ie. the old entry.
TO get the new entry I read the key fields of the table TCJ1T form DBTABLOG and query TCJ1T using a select query. The issue is that if an entry is updated twice I can only get the latest updated record if I read the table TCJ1T and the previously updated value is lost.
Is there a way to read the old value , new value using DBTABLOG.
Thanks and Regards
Ashwin