× 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.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

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.