RE: Record Number -- RPG400-L

Booth, Jim,

In RPG-III, as in Booth's example, retrieving the file's current RRN cannot
be done reliably with just the code you provided.  For input-only files, you
risk getting the first RRN in the block of records read.  So, for example,
on your first read you get a block of records that consist of RRN 1 through
8, the INFDS will report the RRN as being 1 for each of those 8 records.  I
believe the way to overcome that is to OVRDBF NBRRCDS(1), although I may be
wrong on that.  Since no record blocking occurs with an update file, you
could use this technique without the OVRDBF.

In RPG-IV, I seem to recall that Barbara Morris stated a few months ago that
the INFDS reports the current RRN at all times, regardless of record
blocking or the fact that the file is input-only.  

O.K., I just looked it up in the ILE RPG Programmer's Guide, Appendix 1.1.4
(Behavioral Differences Between OPM RPG/400 and ILE RPG for AS/400) I/O:

    8.  In ILE RPG, the relative record number and key fields in 
        the database-specific feedback section of the INFDS are 
        updated on each input operation when doing blocked reads.

- Dan Bale


-----Original Message-----
From: Martin, Booth [mailto:BoothM@goddard.edu]
Sent: Wednesday, February 16, 2000 3:18 PM
To: 'RPG400-L@midrange.com'
Subject: RE: Record Number


Jim, this worked for me:

     FAPDUE     IF   E             DISK
     FAPDUE1    IF   E           K DISK    INFDS(DB1)              
     F                                     RENAME(RAPDUE:RAPDUE1)  
     FAPDUE2    IF   E           K DISK    INFDS(DB2)              
     F                                     RENAME(RAPDUE:RAPDUE2)  
     FAPDUE3    IF   E           K DISK    INFDS(DB3)              
     F                                     RENAME(RAPDUE:RAPDUE3)  
     D DB1             DS                                          
     D  DB1RRN               397    400B 0                         
     D DB2             DS                                          
     D  DB2RRN               397    400B 0                         
     D DB3             DS                                          
     D  DB3RRN               397    400B 0

Then, on the subfile I put DB_RRN into a hidden field and could show file 1,
2, or 3 in the subfile, depending on which file the user requested, and then
when a user selected a subfile item I could READS and chain to the unindexed
physical file with RRN for updates.


-----Original Message-----
From: Jim Langston [mailto:jlangston@conexfreight.com]
Sent: Wednesday, February 16, 2000 11:46 AM
To: boothm@goddard.edu
Subject: Record Number


I am searching through a file for some strings, and I need to find out
what the record numbers are.  I am opening the file Input, Full Procedural,
externally described, and as I understand it, this uses sequential
processing,
that is, record numbers.

Once I find my string, how do I find out what record number I am actually
on?  Until I find out I am going to just increment a counter and hope it's
right, but as we all know, deleted records mess this up.

Thanks.

Regards,

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