topic Re: DB table entry log in Application Development and Automation Discussions

DB table entry log

Former Member — Thu, 12 Jun 2008 13:47:54 GMT

HI all,

i want to find out entry log for database table. i mean i have one ztable it contains some data, i want to know who and when entered that data. some programs are using this table. one of the programs are not working properply and populating wrong data to dbtable so i need to find that program.

is there any way to find out which program is populating wrong data and who has run that program

thanks.

Re: DB table entry log

Former Member — Thu, 12 Jun 2008 13:50:28 GMT

Hi,

First thing is that the Table Logging Option must be checked in your Table attributes.

If it is checked, you can check in the table: DBTABLOG

Regards,

Ravi Kanth Talagana

Re: DB table entry log

Former Member — Thu, 12 Jun 2008 14:19:20 GMT

where i need to check table logging option.

Re: DB table entry log

Former Member — Thu, 12 Jun 2008 14:25:01 GMT

Go to Technical Setting

and check checkbox Log Data Changes

Regards,

Anil

Re: DB table entry log

Former Member — Thu, 12 Jun 2008 14:26:44 GMT

Hi ,

Go to Se11 and give your table name and click display.

Click on the Technical settings button.

There will be a check box for "Log Data Changes".

It should be checked in order to find entries in DBTABLOG.

There will ne no use if you check it now, as it would not have recorded the changes till now. It will log the changes only from now onwards.

Regards,

Ravi Kanth Talagana

Re: DB table entry log

Former Member — Thu, 12 Jun 2008 14:28:05 GMT

No it is unchecked.

Re: DB table entry log

Former Member — Thu, 12 Jun 2008 16:23:05 GMT

In this case Log will not get created for your Ztable.

Regards,

Anil