RE: urgent

["Bale, Dan" <DBale@xxxxxxxx>]

No.  What Chris was describing is a technique used to update a record in a
file for which you may find duplicate keys.  When loading a subfile from
such a file that is used to allow the user to modify the record, you need to
store the data file's RRN in the subfile record.  If the user makes a change
to the record, your program recognizes that a change was made, and it uses
the RRN to chain out to the physical file to udpate the record.

Note that the data file's RRN is found in the file's information data
structure (INFDS).  Also note that in RPG-IV, the RRN is always correct,
regardless of any blocking factors.  This is not necessarily true for
RPG-III.

HTH,
Dan Bale

> -----Original Message-----
> From: rajan tangri [SMTP:rajantangri@hotmail.com]
> Sent: Tuesday, May 16, 2000 8: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
> 
> >From: Chris Bipes <rpg@cross-check.com>
> >Reply-To: RPG400-L@midrange.com
> >To: "'RPG400-L@midrange.com'" <RPG400-L@midrange.com>
> >Subject: RE: urgent
> >Date: Mon, 15 May 2000 14:49:08 -0700
> >
> >I've chained to a non-keyed PF by RRN when the file is not unique keyed
> and
> >an update/delete option was chosen as a subfile option.  (We hide the RRN
> 
> >in
> >the subfile record when we load it. hee hee hee.)
> >
> >
> >
> >Hi
> >
> >I need to chain a field in a file(non-keyed) with a field in another
> >file(multiple keyed), but having different keyed sequence. Creating a new
> >logical file is not allowed.  Can you help me out?
+---
| 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
+---