Re: Re: set on lr -- RPG400-L

--
--
[ Picked text/plain from multipart/alternative ]
Buying books is nice, but also consider reading the archives at www.midrange
com, reading the manuals at ibm.com, and looking at sample coding that is
avaialble all over the net.  (by the way, us old-timers learned the same
way: read other people's code, read the manuals over and over, experiment.
ask frieds for ideas.)



---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@MartinVT.com
---------------------------------------------------------

-------Original Message-------

From: rpg400-l@midrange.com
Date: Tuesday, October 15, 2002 09:51:35 AM
To: rpg400-l@midrange.com
Subject: Re: Re: set on lr

Thanks so much.....Iam beginner in this, having been laidoff in
USA...Iam trying to learn this ...Thanks i shall buy the books
what u mentioned if they are useful...
Best Regards
Murali

On Tue, 15 Oct 2002 Steve Landess wrote :
>
>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�ards
>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.
>
>_______________________________________________
>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.

.
--
[ IMSTP.gif of type image/gif deleted ]
--