Now to implement a client history file, that would mean a hell of a lot of
programs to update.
Why? Just Write a after update trigger program.
As soon as the client becomes inactive, i.e. the state gets set, write the
record into the history file and delete the record from the original file.
We handle all our history files in this way.
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!"
-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von David FOXWELL
Gesendet: Friday, 06. November 2009 14:31
An: RPG programming on the IBM i / System i
Betreff: RE: How to treat obsolete information from a physical file
-----Message d'origine-----
De : rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Vern Hamberg
Envoyé : vendredi 6 novembre 2009 14:13
À : RPG programming on the IBM i / System i
Objet : Re: How to treat obsolete information from a physical file
Hi David
If you can't use history files, as Birgitta suggested, start
using a QAQQINI file with the IGNORE_DERIVED_INDEX value set
to *YES. Once you get to v6r1, this is already the default.
But this will eliminate the problem with select/omit files.
Hi Vern Birgitta, I'm looking for the message from Birgitta where I learned
of this problem. I thought that that would stop SQL from finding the index
at all.
That reminds me in fact we DO have one or two history files that are direct
copies of daily transaction files. --
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
midrange.com
