RE: Would it be a reasonable to ask IBM's programmersto write a%sortsfl(sfl: column)

No, no, no. 5250 has no storage. Oh, maybe the 25*80(132) for the
display characters and a little communication buffer (maybe a tiny bit
of control storage) but no storage for anything else. Your subfile is
managed by the *FILE object.

That's the big difference between 5250 and HTTP. Browsers have storage.
You can send the whole stream down and manage it at the workstation. You
can even send programs (javascript, eg) that manipulate the data. And
yes, javascript handles objects. (No, it is not a "object oriented"
programming language.)

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Murphy/STAR
BASE Consulting Inc.
Sent: Tuesday, December 08, 2009 2:56 PM
To: Midrange Systems Technical Discussion
Subject: RE: Would it be a reasonable to ask IBM's programmersto write
a%sortsfl(sfl: column)

Isn't the subfile stored on the terminal itself? If so, it would have
to be some DDS keyword.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx



From: "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxx>
Date: 12/08/2009 03:51 PM
Subject: RE: Would it be a reasonable to ask IBM's programmers to

write a%sortsfl(sfl: column)
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Hmm, maybe just allow an SQL statement to be associated with the SFL,
and allow OS400 to manage the paging through the result set?

-Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Saturday, December 05, 2009 2:37 PM
To: Midrange Systems Technical Discussion
Subject: Re: Would it be a reasonable to ask IBM's programmers to write
a%sortsfl(sfl: column)

But take note of Jon's comment, that it should be in the data
processing, not in RPG, because RPG doesn't see the entire block of
data. So to get this into subfiles really is something database would
need to do, not Rational - now is that rational or not?

Vern

Booth Martin wrote:

Well, this is why I asked the question. If an ordinary RPG programmer

can do the sfl sorting himself, how hard can it be for the real

experts

to do it inside the product?

As to the green screen being dead...yeah. It just takes me a long

time

to accept the death of a friend. (for instance, I finally threw away

my

OS/2 Warp package a year or so ago.)




Jon Paris wrote:

I agree 100% with Scott.

It would have to be done in the OS support as the compiler generated

code never gets to "see" all of the data at once. It handles it a
record at a time just as we do.

With the advent of result field DS I/O, Qualified DS, and Eval-Corr

it

is not exactly hard to do yourself. The version we wrote up here uses

qsort to sequence the array:

http://www.ibmsystemsmag.com/ibmi/developer/8554p1.aspx

and this piece by Susan was a simplified example using SORTA:

http://www.itjungle.com/fhg/fhg100808-story01.html

You could also store the data in a User Space (for example) which
would be useful in a web app where persistence is an issue. The
"secret" is to use a load-all approach and store the data in your own

"buffer" then you can sort any which way you want.

Of course there are those who prefer to use SQL and simply reload
using a different ORDER BY - but for the reasons mentioned in the
article we're not huge fans of that approach.

IBM (if there is an ounce of sense left in their bodies) are not

going

to add features to an obsolete technology when all modern interfaces

offer data grids etc. which achieve this much more easily and with
complete User control.


Jon Paris

www.Partner400.com
www.SystemiDeveloper.com



On 4-Dec-09, at 5:20 PM, midrange-l-request@xxxxxxxxxxxx wrote:

I've always wondered why they didn't do that a long time ago.

However, I think a BIF is the wrong place for this. It should be a

DDS
keyword. It doesn't belong in RPG, it belongs in DDS as an
attribute of the subfile itself. (And therefore available in all
languages that

use
DDS subfiles.)

This should've been done 20 years ago. Now it seems almost too
late! I mean, does it pay to put money into green-screen interfaces

today?