Re: query on PF

[Raul A Jager <raul@xxxxxxxxxx>]

It is possible, but my advise is to eliminate the existing duplicate
keys.  You can use a trigger program to block the adicion of new
duplicated keys.  The trigger can eiter modify the key or send an escape
message.
_________________________________________________________________________________
MURALI DHAR wrote:

> yes u r correct....I already entered duplicate records....i dont
> like to go bak and delete them..from now onwards i want to enter
> only unique records..Iam trying to find some solution to this...i
> think its nt possible...T
> Thanks&Best Regards,
> Murali
> On Tue, 15 Oct 2002 Joe Pluta wrote :
>
> > > From: MURALI DHAR
> > >
> > > I have duplicate records in it...Can i now change it to
> > unique
> > > PF....?
> >
> > Murali, think about what you are asking.  You are asking if you
> > can take a
> > file that has duplicate keys and make it have unique keys.  Only
> > one of two
> > options exist:
> >
> > 1. The operating system deletes records with duplicate keys
> > 2. The operating system keeps the duplicate keys
> >
> > Option one would destroy data.  I doubt this is what you want.
> > Option two
> > is a contradiction, because the keys in the file would not be
> > unique.
> >
> > So, common sense should indicate that the answer is no, you
> > cannot convert a
> > file with duplicate keys to unique key access, without first
> > removing the
> > duplicate keys.
> >
> > If you choose to ignore common sense, you could simply try it
> > yourself, like
> > I did, and find that you'll get a CF4012 if you try to access a
> > unique view
> > over a file with duplicate keys.  I did this by entering data
> > into a file,
> > then changing the file to UNIQUE.  When I went to access the file
> > with
> > UPDDTA I could not access it.
> >
> > On the other hand, I was able to access the data in this mangled
> > file using
> > SQL.  So the answer to your problem might be simply to use SQL.
> >
> > Joe
> >
> > _______________________________________________
> > 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.
> __________________________________________________________
> Give your Company an email address like
> ravi @ ravi-exports.com.  Sign up for Rediffmail Pro today!
> Know more. http://www.rediffmailpro.com/signup/
>
> _______________________________________________
> 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.