Re: query on PF

This will not prevent a program from adding a key that already existed
before the day...

bill.reger@convergys.com wrote:

Murali,

If you really want to leave your existing duplicate records in the file and
ensure uniqueness going forward (I would clean this up personally), there
is a way, assuming you have a current transaction date field or a
sequentially generated key field somewhere in the file.

Create a new logical file that has the same keys as your existing file,
make it UNIQUE, and add select/omit criteria to your new LF to include only
records from this day forward.  Use either "greater than date X" if you
have a current date field, or use "greater than seq.# X" if you have a
sequentially generated key.  Thus this new LF will not include any of the
dups written previously.

Should any of your programs attempt to add a duplicate key, this new LF
will object.

Bill


--
"NOTICE:  The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential.  If you have received this electronic
mail transmission in error, please delete it from your system without
copying or forwarding it, and notify the sender of the error by reply email
or by telephone (collect), so that the sender's address records can be
corrected."

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.