RRN Questions and Answers

Recent IT Questions

1 - 9 of 9
<<PREVIOUS 1 NEXT>>

Is RRN part of the record?

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

View Answer   |  May 4 2009  4:27 AM GMT
RRN, Relative Record Number
asked by Swpa

  5 pts.

Relative record number

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

View Answer   |  Apr 13 2009  8:29 PM GMT
RRN, Relative Record Number
asked by Pwopen12

  160 pts.

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

View Answer   |  Jan 20 2009  11:43 AM GMT
RPGLE, RPGLE Program, RRN
asked by Rajeshece

  440 pts.

DB2/400

Hello Guys, 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...

View Answer   |  Nov 2 2008  11:38 AM GMT
DB2, DB2/400, RGZPFM
asked by BibinGeorge

  110 pts.

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?

View Answer   |  Oct 13 2008  1:27 PM GMT
JOIN statement, RRN
asked by Devilva

  15 pts.

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.

View Answer   |  Jun 13 2008  10:04 PM GMT
DB2, RRN, DB2 capacity
asked by Nay ray

  5 pts.

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

View Answer   |  May 29 2008  9:25 AM GMT
Subfile, RRN, Relative Record Number
asked by Kundankumar 83

  65 pts.

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 ?

View Answer   |  Mar 13 2008  12:48 AM GMT
RPG, CHAIN, RRN
asked by Aum

  15 pts.

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

View Answer   |  Feb 15 2008  7:00 PM GMT
iSeries, SQL, JOIN statement
asked by Isjld

  35 pts.

1 - 9 of 9
<<PREVIOUS 1 NEXT>>