DBF in AS/400 – last record written

130 pts.
Tags:
AS/400
AS/400 Database File
Database Files
RPG
RPGLE
Hi ,

There is  file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it.

 

Thanks



Software/Hardware used:
as400 , rpgle
ASKED: June 22, 2011  3:58 PM
UPDATED: June 22, 2011  9:12 PM

Answer Wiki

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

Using DSPPFM will show you the records in the sequence they were written.
Unless there were deleted records in the file and the file was set to use deleted records.
If you journal the file, you will be able to get them from the journal receiver in sequence.
Or if you put a timestamp as one of the fields in the PF.

Discuss This Question: 1  Reply

 
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
    Journal entries are the best way, and potentially the only certain way. A timestamp field that allows a default will get current time if a value is not specified at the time of INSERT. Tom
    125,585 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