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



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.