RE: SORT on the iSeries...

["Norm Dennis" <nhdennis@xxxxxxxxxxx>]

Michael,
you could try looking at FMTDTA (format data) which provides SORT
functionality but there are a few options to investigate depending upon your
requirements.

Other options could be:
Convert data files to Indexed files
SQL
OPNQRYF

I came across a project in the late 80's where mainframe programmers were
converting a DOS/VSE application to a S/36 application and had included a
number of sort routines until it was pointed out that indexed files would
eliminate the requirement to sort. The same may apply in your case by
creating Indexed or Logical files.

HTH

Norm Dennis

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Michael Rosinger
Sent: Wednesday, 13 December 2006 11:39 PM
To: midrange-l@xxxxxxxxxxxx
Subject: SORT on the iSeries...


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". I find that very hard
to believe. There must be some system provided sorting mechanism. I see that
ILE/COBOL fully supports the SORT verb so that must be interfacing with a
system-provided utility.

I searched for "sort" in the iSeries information center and could not find
any explicit references to a sort program or utility.

Perhaps the person meant that there is no "sort program" that you can
explicitly execute in batch (as you can in the VSE world). Could someone
authoratively clear this up for me please? TIA

--
Regards,

Michael Rosinger
Systems Programmer / DBA
Computer Credit, Inc.
640 West Fourth Street
Winston-Salem, NC  27101
336-761-1524
m rosinger at cciws dot com


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.16/582 - Release Date: 11/12/2006
4:32 PM

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.18/585 - Release Date: 13/12/2006
11:49 AM