AW: Join files

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
************************************************************