PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

No of number records in a PF

View previous topic View next topic Go down

No of number records in a PF

Post  maran on Mon Jul 27, 2009 8:20 pm

How to know the number of records in a PF through CL program?
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

Re: No of number records in a PF

Post  maran on Mon Jul 27, 2009 8:20 pm

1. Through RUNRQY OUTFORM(SUMMARY)
2. RTVMBRD The number of non deleted (current) records NBRCURRCD.
The number of deleted records NBRDLTRCD.
we come to know the total no. of records in a file from the above command through CL program. Especially by using RTVMBRD we will get all the information in a PF.
_________________
Regards,
Razuk.
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

how tom know the no.of records in pf using cl?

Post  muthuraman on Tue Sep 22, 2009 7:19 pm

The correct answer...
use command DSPFD FILE(LIBOBJ/FILEA1) then Enter
then PGDOWN to last there u can see no.of records

Total number of
members . . . . . . . . . : 1
Total number of members not
available . . : 0
Total records . . . . . . . . . . . . . . :
2488

regrads,
Muhturaman.

muthuraman

Posts : 42
Join date : 2009-08-28

View user profile

Back to top Go down

Re: No of number records in a PF

Post  muthuraman on Tue Sep 22, 2009 7:23 pm

another one option is..........

RTVMBRD - Retrive Member Description)

PGM

DCL &NBRRCD TYPE(*DEC) LEN(10 0)

RTVMBRD FILE(FILLIB/FILEA1) MBR(*FIRST)
NBRCURRCD(&NBRRCD)

muthuraman

Posts : 42
Join date : 2009-08-28

View user profile

Back to top Go down

Re: No of number records in a PF

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum