RE: Physical file Data change date/time

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

Actually, I responded too quickly.  Besides QDBRTVFD there is QUSRMBRD, that
will present this information.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
The miles may take us apart but our friendship will always go the distance. 


> QDBRTVFD is the API you need.
>
> Dennis Lovelady
> http://www.linkedin.com/in/dennislovelady
> --
> "Man does not live by words alone, despite the fact that sometimes he has
to
> eat them."
>         -- Adlai Stevenson
>
>
> > I've searched the net and tried the archives, but to no avail.
> >
> > I'd like to programmatically get the date and time that the data in a
> > physical file changed. Not when the object changed but when the data
> > changed, available only (it appears) in a DSPFD statement. My question
> > is "Where does DSPFD get the last change date and time?" It must be in
> > the system somewhere...QUSROBJD shows if for example a member was
> > added... but not when the data was last modified.
> >
> > I found the QADBXREF table in QSYS2 and it seems to have what I want but
> > only files in *SYSBAS not in an IASP.
> >
> > I know that I can do a DSPFD to an outfile and read the outfile but I
> > feel that's rather 'old school' when I'm used to working with API's and
> > getting the exact information I need directly instead of commands to
> > outfile and/or print files.
> >
> > Does anyone know where the system keeps this data? Thanks for any help