Home > IT Answers > AS/400 > AS/400 database
anupsshelke
420 pts.
 AS/400 database
AS/400, AS400 physical file
which command is used to find out the total number of records in physical file? i heard there are 4 ways... 1. dspfd 2.  ?????? 3.  ?????? 4.  ?????? can you please share with me ?....

Software/Hardware used:
software
ASKED: June 8, 2012  7:25 AM
UPDATED: June 13, 2012  3:10 AM
RELATED QUESTIONS
Answer Wiki:
2 DSPF - This will show record count at top of screen 3 Use SELECT COUNT(*) with SQL 4 ??
Last Wiki Answer Submitted:  June 8, 2012  1:11 pm  by  CharlieBrowne   32,785 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,785 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I might think of a number of ways, though they might not all be considered as a “command is used”. For example, CALL is a command and you can CALL any number of programs that give record counts.

But I don’t quite see what problem needs to be resolved.

Tom

TomLiotta
 107,735 pts.
 

I agree with Tom,
But I don’t quite see what problem needs to be resolved.

This sounds like a homework or an interview question.

gfprogrammer
 210 pts.
 

YES SIR THIS IS THE QUESTION ASK TO MY FRIEND DURING INTERVIEW ,

anupsshelke
 420 pts.
 

This could also be a trick question.

When they are asking total records do they men active AND deleted ?
If so the only way I know of seeing the number of deleted in is with DSPFD.

You could also STRDFU option 5 on the file and roll back 1 screen to get the RRN of the last record in the file.

I think charlie may have had a typo on his #2 should it have ben DSPPFM ?

ToddN2000
 3,890 pts.
 

RTVMBRD &FILE NBRCURRCD(&COUNT)

Jfranz
 55 pts.
 

Runqry file(Library/Filename)

tedsoh
 210 pts.
 

In fact, to gull a fool seems to me an exploit worthy of a witty man.
Giacomo Casanova

philpl1jb
 44,070 pts.