Kbase 31986: How to audit database activity from the 4GL.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Solution ID: P1986
GOAL:
How to audit database activity from the 4GL.
FACT(s) (Environment):
Progress 8.x
Progress 9.x
FIX:
Progress has no built-in tool to trace the activity on the database from the 4GL.
You can use database triggers (REPLICATION-CREATE, REPLICATION-WRITE and REPLICATION-DELETE) for the tables you are interested in monitoring.
These trigges may look something like the following, where we assume that traceTable is a table to gather tracing information, and traceSequence is a Progress sequence.
/* traceCreateCust.p */
TRIGGER PROCEDURE FOR CREATE OF customer.
CREATE traceTable.
ASSIGN traceTable.tSequence = NEXT-VALUE(traceSequence)
traceTable.tUserID = USERID
traceTable.tDate = DATE
traceTable.tTime = TIME
traceTable.tActivity = "Create"
traceTable.tTableName = "Customer"
traceTable.tRowID = ROWID(customer).