RE: urgent

[Chris Bipes <rpg@xxxxxxxxxxxxxxx>]

No you do not need to have a subfile!

Just need to chain using a RRN!

But how do you know the RRN?  We know by reading a logical by one non-unique
key and saving the RRN of the retrieved records, hidden in the subfile that
holds the selection of records that the user requested.  This load can be
done via a logical or SQL or QPNQRYF.  But to update/delete one of these
records we chain back to the non-keyed physical by RRN.


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: rajan tangri [mailto:rajantangri@hotmail.com]
Sent: Tuesday, May 16, 2000 5:28 AM
To: RPG400-L@midrange.com
Subject: RE: urgent



Am I getting it right ?
So to read/chain  a non keyed file by RRN ,I have to use a subfile ?
If yes ,I feel it is better to use SQL or OPNQRYF.

Rajan

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