RE: SORT IN AS/400

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
btw, FMTDTA is rarely used on the AS/400 - most prgmrs have never used it,
even though it is often much faster that logicals.  OPNQRYF is also an
option, it is like building a logical file for one-time use.

FMTDTA works based on byte position in the record (which is NOT the norm in
the AS/400 world); most other tools like OPNQRYF sort on field names defined
in physical files.

The obvious advantage of sorting on field names vs byte positions is that as
fields expand, the sort on field name will continue to function, while the
sort on byte positions will give incorrect results.

There is a utility from Jim Sloan's QUSRTOOLS which will take a command and
parms of field names, and convert that into FMTDTA position-bsaed specs.  I
think it is called the SORTDB command, but not sure.



-----Original Message-----
From: veleazar@gseguros.com [mailto:veleazar@gseguros.com]
Sent: Wednesday, April 24, 2002 11:33 AM
To: cobol400-l@midrange.com
Subject: SORT IN AS/400


Este es un mensaje de varios componentes en formato MIME.
--
[ Picked text/plain from multipart/alternative ]
Hi evry body.

I come from an MVS environment and I need desesperatly to sort a file with
out creating any "logical" on it, since the sort criteria and positions
vary from one time to the next.

I used to use DFSORT on the MVS. Is there some thing I can use the same
way?

I'll thank any idea.

Virgilio Eleazar Rodríguez Domínguez
Tel: 963 87 59 00 ext. 6156
Aseval, S.A.
_______________________________________________
This is the COBOL Programming on the iSeries/AS400 (COBOL400-L) mailing list
To post a message email: COBOL400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/cobol400-l
or email: COBOL400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/cobol400-l.