It will be a great use for the new functionality of db2 to give the
values of the table at a certain time and date.

El 30/12/19 a las 18:41, Jon Paris escribió:
User is looking at a list of outstanding invoices.
Notices that one is for a large amount and wonders how many others are in that category.
Sorts the data in amount sequence and looks for the invoice that triggered the thought
Can't find it because (in your scenario) a payment has been made and it is no longer in the list.
User spend a few minutes paging around and thinking about it and decides they must have mis-membered the amount.
Changes back to the original sequence and looks for the customer number - can't find it either for the same reason.

They have just wasted several minutes because when they asked you to resequence the data they (apparently) foolishly expected you to resequence the SAME data.

A little bit of their trust in the system just died.

I have actually watched this happen on a number of sites. Sometimes when I lecture on this kind of topic and mention this situation I can watch the lightbulbs go on in some peoples heads as they have the "Oh! that's why the XDYX screens confuse the users!" moment.

And I was talking about why a load-all was my preferred approach. Not expandable (although similar issues apply) or page-at-a-time.

But as you well know - unless there is no alternative I wouldn't waste time doing anything with a 5250 in the first place.

On Dec 30, 2019, at 4:23 PM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

I can't imagine the scenario you describe, therefore I am not understanding what you have said. Why would I be looking at, say, Smith and decide to Filter for %mith? I mean, the user is already there?

Clearly I am missing something.

What I see mostly is a user working from a random stack of input data, in which case the user is bouncing all around the file. Or a user is working from ordered input of some particular field so a subfile that sorts by columns fills that need. Adding filters on columns is easy and, for the super user, a welcome surprise.

In other words I see no real case today for either the expandable _or_ the singlepage subfile. The days of the 300 baud modems are behind us.

On 12/30/2019 2:12 PM, Jon Paris wrote:
You've clearly never watched a confused user spend time trying to find the record they were looking at that caused them to want to sort/filter the subfile to see "how many others are like this".

My personal take is that once you have displayed a list of items and the user asks you to sort it or filter it - then you should be sorting/filtering_that_ list - not a new one.

That's why I always build subfiles in memory and sequence/filter internally not by re-doing the query which is what your approach results in.

Of course the user should always have the option to refresh the list - but I don't think it should ever be refreshed "behind their back".
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support by shopping at with our affiliate link:

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
-- Verificado por Anti-Virus Corporativo Symantec --

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.