<link rel="stylesheet" type="text/css" href="http://prostarsoftware.com/wp-content/plugins/q-and-a-focus-plus-faq/css/q-a-focus-plus-noscript.min.css?ver=" />

Knowledge Base

How to delete an audit table program

Last Updated: May 02, 2016 08:45AM PDT
I selected the table cm_det and the all the fields and generated an audit program. Now I want to remove the audit trail on the table and would like to remove the entry. I have unselected the fields but I can't unselect the table. I still see the table in tpsoaudit.p even after I hit F7 Generate, to regenerate tpsoaudit. How do I delete an unwanted audittrail for a table. When I hit F5 to delete nothing happens.

1. In Audit/Field Selection, select the table to remove so it has a “>” next to it. Press F5. You should see a message “OK to delete these audit fields? Y/N”. If you don’t see that message, it sounds like an emulation issue – F5 doesn’t map in whatever emulation you are using. Try ctrl-g. 

2. If you get the message and say Yes, then do F7 to generate the code. The original audit program (“audit_cm_mstr.p” or something similar) will not be deleted, but it should no longer get run. The main audit program (“tpsoaudit.p” – is that the main audit program or the one for so_mstr?) will no longer reference it. And the entry in the program table will have been deleted for that record (event = TableAudit, runprogram = audit_cm_mstr.p or similar).

seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found