RE: Secondary Keys

[Chris Bipes <chris.bipes@xxxxxxxxxxxxxxx>]

Then again,  how can you sort by file2 if no matched records exist?
Basically you are saying, I want all records in file1 that do not have a
match in file2 first.  Then the matched records sorted by a field in file2.
Sound like an exception join on file1, load data in any order ( cause you do
not have the sort field).  Then add records from join of file2 & file1
sorted by file2 field.

From where I sit this does not sound right.  If, as a user, I want to sort
this by data in file 2, I expect to only get records that exist in file2.

Christopher K. Bipes    mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst  mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.        http://www.cross-check.com
6119 State Farm Drive   Phone: 707 586-0551 x 1102
Rohnert Park CA  94928  Fax: 707 586-1884

If consistency is the hobgoblin of little minds, only geniuses work here.
Karen Herbelin - Readers Digest 3/2000

-----Original Message-----
From: Contractor1@Parkdalemills.com
[mailto:Contractor1@Parkdalemills.com]
Sent: Wednesday, December 06, 2000 1:52 PM
To: RPG400-L@midrange.com
Subject: RE: Secondary Keys



Good observation. This is where I started. Currently the program only has
two sorts. These use fields solely in the primary file, File1. No problem.
No join. I chain the secondary file, File2, for subfile info. Now, the
request for the third sort. All fields are in File2. I created a matching
join logical with File2 as the primary file. This way if there are any
records in File2 not matching File1 they will not show up in the subfile.
Now the problem. If a record is added to File1 that does not have a
matching key in File2, I can't see it in my subfile. Hence, I need File1 as
the primary file joined with default values to File2.

I had no idea this topic would get this much attention. And I was worried
about boring you folks.

Patrick Conner
www.ConnecTown.com
(828) 244-0822
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---