Answers

Question and Answer:

  Home  IBM DB400

⟩ How to know total no of records in pf with out using sql?

By 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.

 121 views

More Questions for you: