Yes without reading a file we can check the existence of records in a file.

Can we found a record existance in a file w/o reading the file?

Question Posted / nkumar

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

Please Help Members By Posting Answers For Below Questions

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?

1924

give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........

3835

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?

1250

is this a rpg channel?

1173

how do I preserve and clean the array?

1153

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?

956

can you debug ile rpg program using isdb?

1271

which program rpg or cl is efficent to update a transaction onto a database file and why ?

1243

what is the rpg system?

1282

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?

946

what is the procedure and explain about real time scenario.

1959

How can we override a file during runtime in rpg?

1205

What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?

3003

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?

963

What is the difference between copybooks and subprocedures in as400?

1361