How can we read a particular record from the database file
which is not having DDS (Flat File). For example, there are
100 records in the flat file. How can we retrive 15th
record in RPG/400 program (Without using CL)

Answer Posted / swetha p rao

Yes ,Using RRN of the file we can retrive.

Chain the file with RRN or Query the file with RRN
select * from temp33 where RRN(temp33) = 15

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a record lock error?

1266


explain sflclr, sflend, sfldlt, and sflcsrrrn?

889


How to call one program from another program in RPG? please help me with the code

1260


what is program status data structure?

1387


what was the robotech rpg?

684






How Chain operation copies the record's data to the input buffer for the program?

1082


what is the difference between do while and do until?

703


How to write record if no field or the field are different in physical file in rpgle ?

490


how do I declare a minor?

716


how do I play {insert rpg system here}?

585


how do I preserve and clean the array?

675


thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

1895


what is the use of sflnxtchg?

803


1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?

2373


write an RPG program to calculate the marks of 5 students (A,B, C, D, E)in 3 different subjects (eng, math, sci) an display on the screen

831