Kbase P49848: How can I find the creation date of a database?
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  29/11/2005 |
|
Status: Verified
GOAL:
How can I find the creation date of a database?
GOAL:
How to find out the date a Progress database was created using the 4GL?
FACT(s) (Environment):
Progress 8.2x
Progress 8.3x
Progress 9.x
OpenEdge 10.x
FIX:
It is possible to get the date and time of the creation of a database. The _MstrBlk._MstrBlk-Crdate Virtual System Tables (VST) for the database contains this information. Below is an example using 4GL of how to query this table to get the creation date information.
FOR EACH _MstrBlk NO-LOCK:
DISPLAY _MstrBlk._MstrBlk-Crdate.
END.