IBM DB400 Question:
Download Job Interview Questions and Answers PDF
How to know total no of records in pf with out using sql?
Answer:
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.
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.
Download IBM DB400 Interview Questions And Answers
PDF
Previous Question | Next Question |
Can we concatenate fields in physical file? If yes how can we do? | Last statement of any RPG pgm is LR? |