Can we found a record existance in a file w/o reading the file?
Answer Posted / nkumar
Yes without reading a file we can check the existence of records in a file. There are 3 ways.
1) Type DSPFD and define the file and press enter. Go to las and see the total no of records.
2) Using the file information data structure.
3) Using the RTVMBRD using in the CL program and check teh NBRCURRCD filed value. this will have the total no of records.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
which program rpg or cl is efficent to update a transaction onto a database file and why ?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
how can I tell when to replace the array?
What is file identifier where we can use?
What is difference between bind by copy and bind by reference?
How to call one program from another program in RPG? please help me with the code
what is file information data structure?
what is data area and how it is used in rpg program ?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
what is the necessary keyword needed to scroll subfile records?
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?
Explain mdt?