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
explain sflclr, sflend, sfldlt, and sflcsrrrn?
what is the rpg system?
how do I declare a table or array in rpg iv?
What is the difference between iter and do?
are there any useful c runtime apis that I can call from rpg iv?
what is the difference between do while and do until?
is this a rpg channel?
How can we override a file during runtime in rpg?
Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
how can I tell when to replace the array?
How to handle duplicate error handling in RPG?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
how do you use commitment control in rpg?
do you use message subfiles? What are the necessary keywords required coding a message subfile?