Records in subfile are put in another order

70 pts.
Tags:
AS/400 database
AS/400 programming
AS400 iseries
as400-subfile
iSeries v7r1
We implemented an iSeries v7r1 over the weekend . In a particular display the user enters records in a subfile in last name order, when he/she pages down to another screen in the subfile the records change to a different order. The display, physical, logicals and programs have not been changed since 2012. This only started to happen after we upgraded to the new machine (power system v7r1. Does anyone know if there are any release notes regarding this problem?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 4  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.
  • aceofdelts

    Maybe minimal help, but when I get an odd result like this I revisit my assumptions. Usually something I "knew" turns out to be different.

    With OS400 there's always a reason for an oddity - things don't "just happen" (OK, almost never)

    2,510 pointsBadges:
    report
  • pdraebel
    When records with equal keys are read one would normally expect them to be returned in physical file order. However that is not guaranteed. Results of such a read can be different between executions.
    7,545 pointsBadges:
    report
  • philpl1jb
    We don't know how you're program manages page up/page down events.
    54,090 pointsBadges:
    report
  • ToddN2000
    On adding new records how is the file being updated and the sub file refreshed. It is being built by page or the entire sub file. It does seem strange that a release upgrade would cause this issue though. Are we sure that the last name was the primary key or was it a coincidence. Just asking because I have seen some stranger things happen.
    113,660 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.

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

Following

Share this item with your network: