Re: set on lr

["Steve Landess" <steve_landess@xxxxxxxxxxx>]

Murali -

I think you need to take a class or buy a book about AS/400 programming in
RPG.  It also appears to me that you have a lot to learn about subfile
programming and databases.  There are some very good books available at
reasonable prices.  Go look in the midrange.com online book store:
http://store.midrange.com/books.htm .

I don't mind helping you, but I expect YOU to have a basic level of
understanding about some things.  I also expect you to help yourself
whenever possible.  Most of the time I use the midrange forum AFTER I have
exhausted all other avenues.

I would suggest that you start searching for the answers to some of these
questions BEFORE you ask them:

1) on IBM's web site (http://as400bks.rochester.ibm.com),
2) in the FAQs here on midrange (http://faq.midrange.com/data/cache/1.html)
3) or in the forum archives here on midrange


----- Original Message -----
From: "MURALI DHAR" <nmuralidhar@rediffmail.com>
To: <rpg400-l@midrange.com>
Sent: Tuesday, October 15, 2002 2:43 AM
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.