AS/400 database

420 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

2 DSPF – This will show record count at top of screen
3 Use SELECT COUNT(*) with SQL
4 ??

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • gfprogrammer
    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.
    250 pointsBadges:
    report
  • anupsshelke
    YES SIR THIS IS THE QUESTION ASK TO MY FRIEND DURING INTERVIEW ,
    420 pointsBadges:
    report
  • ToddN2000
    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 ?
    9,815 pointsBadges:
    report
  • Jfranz
    RTVMBRD &FILE NBRCURRCD(&COUNT)
    55 pointsBadges:
    report
  • tedsoh
    Runqry file(Library/Filename)
    210 pointsBadges:
    report
  • philpl1jb
    In fact, to gull a fool seems to me an exploit worthy of a witty man. Giacomo Casanova
    49,830 pointsBadges:
    report
  • anupsshelke
    [...] 8. ToddN2000 and Philpl1jb think Anupsshelke might have asked a trick question about what command is used to find the total number of records in a physical file. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following