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
Interviewer asked me write down DDS for load all subfile .can anybody write dds
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?
What is the difference between copybooks and subprocedures in as400?
what is data area and how it is used in rpg program ?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
is this a rpg channel?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
what is file information data structure?
How can we override a file during runtime in rpg?
what is an online rpg?
what is the procedure and explain about real time scenario.
How many program bind in one module....
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
can I touch the array during treatments?