1 - 9 of 9
PREVIOUS 1 NEXT
5 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
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
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...
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...
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?
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?
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.
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.
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...
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...
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 ?
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 ?
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...
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...
1 - 9 of 9
PREVIOUS 1 NEXT
