1
  • How to find indicator and relative record number fields in DB2/400

    In DB2/400, even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number) field? I tried with RUNQRY...

    BibinGeorge130 pointsBadges:
  • How to fetch data from physical file using RRN value of a record ?

    I want to fetch / read a record with given RRN value in rpg. How to read a record for which only RRN value is given, in RPG ?

    Aum15 pointsBadges:
  • Highest RRN in a Subfile

    Does anyone have the positions for the highest RRN on a Subfile? This was found in the old CPF programmer’s guide a hundred years ago. It was right after the Lowest RRN currently displayed on the subfile. This info comes from the INFDS. Are there examples?  

    Nickhutcheson165 pointsBadges:
  • AS/400 Scenario

    Q. I have a file with millions of records and I want to read the last record from that file.But the conditions are as follows(assume): 1. The file do not have any key field. 2. The file do not give any RRN Number(Assume). 3. We are not allow to use the loop till EOF as we have millions of records....

    ankit2002770 pointsBadges:
  • CPYF thru RRN

    CPYF: Copy the records by the keyed sequence.[Br style="padding: 0px; margin: 0px;" />[Br style="padding: 0px; margin: 0px;" />But i want to copy the records in arrival ( RRN ) sequence.[Br style="padding: 0px; margin: 0px;" />[Br style="padding: 0px; margin: 0px;" />Please advice me... I think the...

    22917515 pointsBadges:
  • AS/400 Error: RRN() does not start from 1, but starts from number of rows deleted + 1 db2, v5r4m0

    i'm trying to populate a field in A table with the row number using rrn(tablename). the first time if i insert 4 rows then the id is 1,2,3,4 as required. if i delete the rows and try the insert again the rrn() does not return the same so 1,2,3,4 but returns 5,6,7,8 (that is the nr of rows deleted +...

    Elai45 pointsBadges:
  • RRN and JOIN…

    I have two files and I'd like to join and make a group-by on a xycod, in order to count the number of occurrences. This is the question: What happens on the RRN filed when i try to do group by statement? There is one-to-many relation between records and RRNs, so which is the RRN assigned to it?

    Devilva15 pointsBadges:
  • RRN Max

    Is there a way to allow more than 1 billion records in a DB2 File? We have reorged to file to get rid of deleted records, but are still out of room. The system will not allow one more record to be added because we have reached 999,999,999 records.

    Nay ray5 pointsBadges:
  • Is RRN part of the record?

    I have one doubt whether RRN is part of Record or not

    Swpa5 pointsBadges:
  • Relative record number

    How do we see(display) relative record number(RRN)

    pwopen12240 pointsBadges:
  • AS400 – RRN of PF

    FILE1 is a PF. I want to read 100th Record directly. I want to perform this operation without using LF, OPNQRY, Native I/O. want to achieve this using RRN value of File. How to code this in RPGLE Program

    rajeshece1,215 pointsBadges:
  • RPG – Subfile – Read using RRN

    Is it possible to read a subfile record if its RRN number is known? In my case, when on a subfile record, if F4 is pressed a Prompt window is displayed to list codes. When a code is selected I want this selected code to appear in my subfile record for which the F4 was pressed. In my case I have RRN...

    Kundankumar 8375 pointsBadges:
  • SQL statement using RRN(file) on join pulling only Max(date) records from second file in iSeries

    I am using WebSmart with the I-series data base files. I am joining two data base files receiving the RRN so that I can use the fetch rrn and the fextnext to display one screen at a time in my WebSmart program. I have used this method many times except this time I have a one to many relationship...

    Isjld35 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following