Consultor Eletrônico



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.