How to know total no of records in pf with out using sql?
Submitted by: AdministratorBy using dspfd command you can find out total on record.
dspfd (libname/filename)
here u can find out total no of records.
1. Through the RPG program, Open Feedback Information of
File Information data structure (INFSR) will give the count
of records in the physical file.
2. Through CL command, Retrieve Member Description (RTVMBRD)
will give the no.of non-deleted records through NBRCURRCD
variable.
Submitted by: Administrator
dspfd (libname/filename)
here u can find out total no of records.
1. Through the RPG program, Open Feedback Information of
File Information data structure (INFSR) will give the count
of records in the physical file.
2. Through CL command, Retrieve Member Description (RTVMBRD)
will give the no.of non-deleted records through NBRCURRCD
variable.
Submitted by: Administrator
Read Online IBM DB400 Job Interview Questions And Answers
Top IBM DB400 Questions
☺ | How to update physical file using logical file with example? |
☺ | Why Journalling is compulsory before Commitment Control? |
☺ | Why we create the Physical File Member? |
☺ | Last statement of any RPG pgm is LR? |
☺ | Maximum how many fields we can create under a record format of PF? |
Top Mainframe Technical Categories
☺ | IBM MainFrame Interview Questions. |
☺ | IBM AS400 Interview Questions. |
☺ | JCL Interview Questions. |
☺ | IMS DB Interview Questions. |
☺ | CICS Interview Questions. |