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



Hi,

Did you specify the keyword DYNSLT when defining your join logical file?
If so, just try to remove it. 

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von lgronewold@xxxxxxxxxxxxxxxxxx
Gesendet: Tuesday, January 30, 2007 19:08
An: rpg400-l@xxxxxxxxxxxx
Betreff: Join files



I have a question on Join files:

    The first is on joining files.  I have two physical files that have been
    joined.  The first one is a customer master file that has one member and
    582363  total records (no deleted records).  The second file is a
control
    file that has 8 records (40 deleted records) and one member.  A join
logical
    was created over the two physical files.  The customer file is the first
    file and is joined to the second by customer number.  The files are
sorted
    by customer name and number.  In my program I allow the user to type in
the
    customer name.  I then set lower limits to the join file by the entered
    information and read it.  I then display information from the join.  The
    problem is that it takes over 5 minutes to display the information. Does
    anyone have any suggestions on what the problem is?  Is a join a valid
    option in this program?  There was debate over the use of a join file.

Lori Gronewold
GBS Developer





***************************Disclaimer*************************** 
The contents of this e-mail and any file transmitted with it are
confidential and intended solely for the individual or entity to whom they
are addressed.  The content may also contain legal, professional or other
privileged information. If you received this e-mail in error, please destroy
it immediately.  You should not copy or use it for any purpose nor disclose
its contents to any other person. The views stated herein do not necessarily
represent the view of the Company. Please ensure you have adequate virus
protection before you open or detach any documents from this transmission.
The Company does not accept any liability for  viruses. Premier Farnell plc
150 Armley Road Leeds LS12 2QQ Telephone +44 (0) 870 129 8608 Fax +44 (0)
870 129 8610 
Registered in England
Company Number 876412
Registered Office: Farnell House, Forge Lane, Leeds LS12 2NE
************************************************************ 


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.