Re: SORT on the iSeries...

[Pat Barber <mboceanside@xxxxxxxxxxxxxxxx>]

There are three ways to sort:

(1) Opnqryf/SQL
(2) FMTDTA
(3) logical files or views

(1) The more popular way for temporary reports
    or not wanting to create a logical. Record
    selection with lots of options.

(2) An older method that you are familar with
    (Sort in a input file and create a sorted output file)

(3) The permanetly sorted file. The logicals can be very
    effective but do get abused by folks who create them
    and then never use them again. The overhead can be
    substantial with a large database with lots(hundreds)
    of logicals created over the one file. Requires almost
    no program changes to work.

#2 is your very old method that works quite well and will
be closer to your MVS methods. Since you have to store the
sort specs in a source file, you have no variable run time
selection and this can be a pain. I would use one of the
other methods over FMTDTA....

I prefer opnqryf for batch type work since it fits right in
with CLP. You will hear a lot about SQL.



Michael Rosinger wrote:

> List,
>
> This is an iSeries newbie question so please bare with me. We are getting 
> started on the project of migrating applications (all batch) from VSE 
> (mainframe) to iSeries. I was "told" by someone that is a long-time AS/400 
> person that "there is no system sort on the iSeries".