Question & Answer
Question
How do you determine when an object was created/updated?
Answer
There is a way to find out the date/time when a DDL was performed last on an object. You can find out the date/time when a view was modified with a CREATE or REPLACE VIEW statement as follows:
1. Log in to the database where the object is defined.
2. Execute the following query as ADMIN or a privileged user:
select * from _t_object where objname='<Object Name>' and objdb=current_db;
Output similar to the following appears:
Note: Due to display limitations, several columns of output (OBJOWNER, OBJMODIFIER, OBJCLASS, OBJDELIM, RESTOREDOID) have been omitted.
OBJID | OBJDB | OBJNAME | OBJCREATED | OBJMODIFIED
--------+-----------+------+--------------------+-------------------
1723766 | 261904 | TEST | 2008-2-25 19:31:23 | 2008-2-25 19:32:08
(1 row)
- OBJMODIFIED corresponds to the date and time of the last update to the object.
- OBJCREATED corresponds to the date and time that the object was created.
Historical Number
NZ251164
Was this topic helpful?
Document Information
More support for:
IBM PureData System
Software version:
1.0.0
Document number:
466613
Modified date:
17 October 2019
UID
swg21574774