× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Jim

Do the journal entries have information more current than DSPFD? The member list option of the latter has a last changed date and time. Seems a simpler approach to me, but I've not tried the journal approach lately.

Vern

On 4/8/2011 7:36 AM, Jim Oberholtzer wrote:
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.