RE: SORT IN AS/400

[veleazar@xxxxxxxxxxxx]

Este es un mensaje de varios componentes en formato MIME.
--
[ Picked text/plain from multipart/alternative ]
Thanks Joel, the FMTDTA works great as it is, and as I have oly one field
all the record long but I and I can trust the sort field is going to be
correctly express in an external source, I can build a source file
each time containing the correct sort instructions.

Any way, I'll take note for future use.

Thank you every body

Virgilio Eleazar Rodríguez Domínguez
Tel: 963 87 59 00 ext. 6156
Aseval, S.A.

__________________


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.
_______________________________________________
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.