Insert and Amend Datestamps

Insert and Amend Datestamps

Question:
I have a table in Informix that is changed regularly. The records have no datestamp, so how do I get the date/time of amends and inserts to this table without altering the table structure or using triggers (I can’t do any alterations to the database)?

Answer:
You may want to look at the auditing capabilities of the later Informix engines. If your engine is recent enough to support auditing, you can track many types of security-related items with the auditing facility.

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular