RE: set on lr

["Manoj S. T., Gurgaon" <manojst@xxxxxxxxxxxxxxx>]

U can use RETURN but it won't close all open files.

-----Original Message-----
From: MURALI DHAR [mailto:nmuralidhar@rediffmail.com]
Sent: Tuesday, October 15, 2002 1:14 PM
To: rpg400-l@midrange.com
Subject: set on lr


Is there any alternate way of terminating program other than SETON
LR......
adv thanks&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.