RE: The creation date of a record in a PF?

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Hi Charles,

It's common practice to add a timestamp field for the record creation 
date-time, though there are other ways to go about this.  A variation on this 
theme is a change log that is managed by a trigger.  Both approaches require 
code to be developed to capture and maintain this information.

Perhaps the file is journaled, in which case you could retrieve the date for 
that record from the journal.  However, if the record is very old, it may be 
unlikely that the journal receiver that held the entry for that record is still 
available on the system.  I do not know any other way to determine record 
creation date and time.

hth,

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Charles St-Laurent
Sent: Tuesday, September 05, 2006 8:28 AM
To: midrange-l@xxxxxxxxxxxx
Subject: The creation date of a record in a PF?


Hi!

Is there any standard command to know the creation date of a record in a
physical file?

Thanks in advance for your answers

Charles