Re: Multiple sort option logic

Is the printed output going to be the same, no matter what? You may want to
use the FMTDTA command based on the user's selection. You store the sorting
logic as a source physical file member, and use it when necessary. If you're
more comfortable with logicals, try having multiple logical file formats
stored as source members. Then you can compile the logical on the fly into
qtemp lvlchk(*no) and then jsut override to that file with your CL program.

BTW, FMTDTA works just as efficiently, if not better than OPNQRYF. Just ask
Jim Sloan....:-))

Paul Nelson
Braxton-Reed, Inc.
630-327-8665 Cell
708-923-7354 Home
pnelson@braxton-reed.com
----- Original Message -----
From: "Dan Rasch" <drasch@mail.win.org>
To: <midrange-l@midrange.com>
Sent: Tuesday, April 23, 2002 3:49 PM
Subject: Multiple sort option logic


>
> We have a requirement to print multiple variations of an aging
> report, giving users 4 different sort groups.  The matrix looks
> like about 80 combinations.
>
> The users will have an input screen of some kind to define their
> sort definitions.
>
> Right away, I thought OPNQRYF using variables might do the trick.
> Ugly IMHO but effective.  Then I wondered aloud if SQL would be a
> better avenue.  We almost certainly have partial paths out there,
> so we do not start from zero, but then again it could also get ugly.
> Also, the ability to save at least a definition (even better, a full
> path) would be an attaboy.
>
> Trying to weigh the maintainability versus the performance, and looking
> for suggestions.
>
> TIA
>
> Dan Rasch - because if the human species concentrated on the really
> important things in life, there would be a shortage of fishing poles!
> IBM Certified twice....... but still a couple PTFs away from Nirvana.
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>