Total # of records in a file

rajkumar400 on Mon Dec 27, 2010 8:46 pm

What is the simplest way to find out total # of records in a file?

Thanks.
Raj

soundhar on Mon Dec 27, 2010 10:09 pm

Using DSPFD u can get number of records in a file

rajkumar400 on Wed Dec 29, 2010 2:16 am

ThANKS. But inside the RPG.

soundhar on Wed Dec 29, 2010 11:17 am

In command line,Using DSPFD u can get the total no. of records...
In CL,Using RTVMBRD u can get this by NBRCURRCD(ie number of current records)...
In RPG,Using FILE INORMATION DATA STRUCTURE(ie infds) u can get this...

By calculation also we can find this,inside RPG
step0:In F Spec,declare the file as I/P mode
step1:initialize a variable say "X" to 0
step2:READ a file 31
step3:*IN31 DOWEQ *off
step4:ADD 1 to X
step5:Read a file 31
step6:ENDDO
Now X contains number of records

rajkumar400 on Wed Dec 29, 2010 11:06 pm

Thanks. I will go with INFDS DUE TO performance.

soundhar on Fri Dec 31, 2010 11:31 am

One thing i forgot to say

IN CL,u have one another way to find the number of records...

Using RUNQRY,with outform(*summary) u can find this...

PGM
RUNQRY QRYFILE((PMS90/EMPMST)) OUTFORM(*SUMMARY)
ENDPGM

razuk_r on Fri Dec 31, 2010 7:35 pm

Added to this we can use SQL400 or SQLRPG. select count(*) .....

soundhar on Sat Jan 01, 2011 10:15 pm

thanks bro

Sponsored content

Total # of records in a file

Total # of records in a file

Re: Total # of records in a file

Re: Total # of records in a file

# of records

Re: Total # of records in a file

Re: Total # of records in a file

Re: Total # of records in a file

Re: Total # of records in a file

Re: Total # of records in a file