Re: Find last date updated using SQL

My suggestion was extract the data needed from the journal receivers. Once that's been done, presumably to a table of some sort, dump the receiver. I happen to know this particular system and the files he is talking about (many of the counties in WI use the same set up) and they are not that large, so it is manageable. Took me about 3 - 4 hours to get the whole thing done for one county in NorthCentral WI. Most of these systems are still 820s, 810s, and a few 520s.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 4/8/2011 7:22 AM, rob@xxxxxxxxx wrote:

Doesn't that require you retain your journals for quite some time?

Our journal receiver library is, by far, our biggest library on our
system.


Rob Berendt
-- Group Dekko Dept 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com From: Jim Oberholtzer <midrangel@xxxxxxxxxx> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> Date: 04/07/2011 12:52 PM Subject: Re: Find last date updated using SQL Sent by: midrange-l-bounces@xxxxxxxxxxxx Dave, By far and away the easiest way to do that is to run Journals on those files you care about and pull the information from the journals. Another way would be to use auditing but that my not provide you with the level of information you need. Jim Oberholtzer Chief Technical Architect Agile Technology Architects On 4/7/2011 11:02 AM, Dave Boettcher wrote:

> On a somewhat regular basis, we need to determine whether or not the

data in tables in a schema have been updated. There are about 100 tables
in this schema and an update is run daily. Not all tables are necessarily
updated each day. I have been just doing a DSPFD and scrolling down to
the member list and looking at the last change date and time for the
member.

> This morning I thought there must be a way to find this using the SYS*

tables created when you create a schema so that I could automate this
checking process. I have looked at QADBXREF and QADBIFLD but have only
found when the table itself was last changed, not when the data changed.
So I ran DSPFD *MBRLIST to an out file and of course it's there as last
change date. But isn't there a place on the system provided tables where
it would be also?

>
> All help is appreciated.
>
> TIA,
>
> Thanks,
>
> Dave B
>
> Two rules to eliminate stress:
> 1. Don't sweat the small stuff. 2. It's all small

stuff.

>