×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
"1. Start journaling the table. I suggest omitting open and close entries."
Do you know the parameter(s) for that?
-----Original Message-----
From: Monnier, Gary [mailto:Gary.Monnier@xxxxxxxxx]
Sent: Wednesday, January 06, 2016 3:38 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Log all PF changes?
Thanks,
Gary Monnier
IT Software Engineer CSM, CSPO
There's this...
1. Start journaling the table. I suggest omitting open and close entries.
2. Clone the source for the table in question; renaming it and adding any additional columns you desire: user altering the row,
action taken (insert, update, delete), timestamp for row creation and change if not there already.
3. Write a program that reads the journal entries, formats the entry specific data to the cloned table and writes records to it.
This can be a NEPs program.
4. Use the cloned table to report from.
Now you can let the table grow to whatever size you want. Saving the journals & their receivers provides to the ability rebuild the table if necessary.
You also have the data necessary to rebuild the original table if such a thing becomes necessary.
Hope this helps.
Gary
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.