RE: [EXTERNAL] sql to obtain date shown in PDM for member (f14)

Did you check, whether the Last_Source_Update_Timestamp within the
SYSPARTIONSTAT catalog view matches the PDM date?
If so, determining all source members (Table_Partition) with that are
changed since 2006, should be very easy:

Select a.*
from syspartitionstat a
Where System_Table_Name = 'QSQLPGM' and System_Table_Schema = 'COMDBPGM'
and Year(Last_Source_Update_Timestamp) >= '2006';


Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jay
Vaughn
Sent: Mittwoch, 9. Oktober 2019 20:50
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [EXTERNAL] sql to obtain date shown in PDM for member (f14)

thanks alan but ultimately that is looking at the object and our object
create/change/last used dates get out of whack and are unreliable due to
operational processes (backup/restores/etc).
So ultimately need to take this to the member level but want to avoid
scanning source members if I can help it.

I'm simply needing any file that had "source code" changes since 2006.

Anyone know where to get that date that PDM shows for each member?

Jay

On Wed, Oct 9, 2019 at 2:45 PM Alan Shore via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Try
DSPOBJD, filling in object name, library and object type being *file
Take option 5 in the next screen That will show the creation date on
the first screen and the second screen will show Change date/time Last
used date


But it's the creation date that I think you are looking for Alan Shore
E-mail : ASHORE@xxxxxxxx Phone [O] : (631) 200-5019 Phone [C] : (631)
880-8640 'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On
Behalf Of Jay Vaughn
Sent: Wednesday, October 9, 2019 2:40 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>;
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] sql to obtain date shown in PDM for member (f14)

I've tried to do a dspfd type(*mbrlist) but the last changed date does
not correspond to what I find in pdm when i press f14.

I need to know the last time the file/member (source) changed.

anyone know?

Jay
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com