Welcome Guest | My Membership | Login

Auditing Database Changes with UniVerse Indexing Subroutines


The UniVerse database has supported file triggers for some time, not just on UniVerse SQL tables. They are fully compliant with the standard SQL model for triggers — before and after insert, update, and delete events; referential integrity; cascading; the ability to modify or terminate an update; and so forth. Obviously, supporting all this functionality involves a noticeable amount of overhead. But in the Real World, our traditional MultiValue applications manage all of this themselves. The primary use of file triggers I have seen is as a way to capture database change events in order to log them as part of IT governance auditing (SOX, HIPPA, etc.).

In UniVerse release 11.1, Rocket Software has provided us a way of using indexing subroutines to capture changes to a file. To completely understand how this new technique works, let's first review the normal use of indexing subroutines.

The purpose of an indexing subroutine is to derive the index value that is to be cross referenced with the record key. For example, say that we had a need to be able to quickly retrieve all of the purchase orders entered by a particular employee for a given accounting period. Accounting periods do not always follow calendar months. So for our particular industry, in order to determine the accounting period of a particular date, we might have to look up the information in a period table. We could have a subroutine whose job it was to take the purchase order date out of the record, look it up in the period table, and catenate the period with the user login ID. We then create an I-type descriptor in the dictionary that calls this subroutine then build an index on that I-type. Anytime we add, change, or delete a record, UniVerse is going to want to update that index appropriately.


Social Media Login

Use your existing social media logins to access your Membership/Subscription information.

Existing Magazine/Newsletter Subscriber (Quick Access)

If you are an existing International Spectrum subscriber, but have not registered with the website, please enter the Reference Code found on the magazine or in the e-mails you receive from us.

Magazine Reference Code location

Spectrum Login

New Subscriber

If you currently do not receive the Magazine or other emails from International Spectrum, select the "Subscribe" button below to create an new membership account.


Find out more about the different between the FREE and a Professional Membership at:
Compare Account Options


# # #          # # #          # # #


Related Articles

  • From The Inside September/October 2011

    Company: International Spectrum

    I need your help in getting the message out that MultiValue is a modern, robust, solution-oriented platform that works well in a multi-system, mainstream environment.

  • Useful Tips on Migrating from Legacy PICK

    Company: Rocket Software

    Useful Tips on Migrating from Legacy PICK Your system sends up certain red flags when its performance has degraded. These signals might include missing your maintenance windows, users complaining about slow system response times, or unreasonably high system maintenance fees. Perhaps your customers are saying the application needs modernization, but the programming backlog is six months and growing. How do you solve these problems? Replace your legacy PICK system!

  • Sending E-mail From Your MultiValue Programs - Part 5: Creating and Sending E-mails with HTML and Text Sections

    Company: International Spectrum

    In the early days of e-mail, text was King. If you dared use that horrible, evil, Microsoft Outlook mailer and sent HTML-based e-mail, you had better be wearing asbestos underwear, because you were going to get flamed. Today, HTML e-mail is the norm for all large businesses (at least in the USA), and the text-only pundits are considered to be somewhat Luddite. Then came mobile devices with small, hard to read screen sizes. What to do? What to do? Enter the realm of multipart html/text e-mail.

  • Business Tech: MultiValue in the Clouds

    Company: HDWP

    Although there are still concerns with Cloud Computing — data privacy, guaranteed service levels, etc. — it appears that the Cloud is here to stay. So what will it take to be able to deploy your MultiValue applications in the Cloud? (Hint — you are almost there already.)

  • Tech Tip: Reality CSV Files

    Interacting with delimited file structures for import and export is very important within your enterprise software. Comma Separated Values format is the most common.

Return to top