How do I get a system generated report for a list of changes to tables/structure in Informix.

Thanks

Also looking for a way generate a report to determine the date/time stamp of changes implemented .

Hi,
I suggest you that daily run dbschema -d databasename -t all -f all -q
Then compare this files.

Gustavo.

hi

you can turn on the feature called AUDITING for all
the databases.

there are specific auditing events are there like ACTB,INRW,DIRW

you can set those events to monitor who are all accessing
the datbase/tables.

userid,timestamp,everything you can see inside the log file