Kbase P72901: Can database schema triggers be created for the _CONNECT table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/27/2005 |
|
Status: Unverified
GOAL:
Can database schema triggers be created for the _CONNECT table?
GOAL:
How to monitor the contents of the _CONNECT table?
FIX:
Although it is theoretically possible to create triggers for the _CONNCET table by un-freezing and un-hiding that table, Progress neither recommends or supports any direct manipulation of this or any other of the schema or VST tables.
One way to monitor the _CONNECT table is to periodically run a procedure that would examine the records of that table. These records may be stored in a temp-table or indeed another table. Reports then can be run against the temp-table or the other table to get information about the various connections. The following snippet shows how to create a TEMP-TABLE that would capture the data from the _CONNECT table into a temp-table:
DEFINE TEMP-TABLE MyConnection LIKE _Connect.
FOR EACH _Connect:
CREATE MyConnection.
BUFFER-COPY _Connect TO MyConnection.
END.
FOR EACH MyConnection:
DISPLAY MyConnection.
END.