Re: Sorting large file

[booth@xxxxxxxxxxxx]

Oh.  Variable key length, varying starting position. 

The single greatest weakness of FMTSRC is that it is about the last 
remaining AS/400 database tool that requires that the starting position be 
a column number, and requires that the length of the sort field be a 
number.

Look at FMTSRC.  It'll do what you want and is fast.
_______________________
Booth Martin
Booth@MartinVT.com
http://www.MartinVT.com
_______________________




"Leif Svalgaard" <leif@leif.org>
Sent by: owner-midrange-l@midrange.com
10/04/2000 05:30 PM
Please respond to MIDRANGE-L

 
        To:     <MIDRANGE-L@midrange.com>
        cc: 
        Subject:        Re: Sorting large file

1) one variable key given by starting position and length
2) batch I guess (will kill interactive -- I guess -- could be a good 
CFINT1
exerciser :-)  )
3) several times on demand
4) max time?  as quickly as possible. I mean, if it has to done, it has to 
be
done.
anything like SYNCSORT as on the z900 ?


----- Original Message -----
From: Jim Franz <franz400@triad.rr.com>
To: <MIDRANGE-L@midrange.com>
Sent: Wednesday, October 04, 2000 3:43 PM
Subject: Re: Sorting large file


> questions: big key or little key?
> sorting on one area of file (like bytes 12-22) or multiple areas?
> interactive or batch process?
> what is max time that you could live with?
> one time run, daily, hourly,??????
> jim
> ----- Original Message -----
> From: "Leif Svalgaard" <leif@leif.org>
> To: "List Midrange" <MIDRANGE-L@midrange.com>
> Sent: Wednesday, October 04, 2000 3:11 PM
> Subject: Sorting large file
>
>
> > Folks,
> >
> > I have a sequential file of 10,000,000 80-character text records.
> > How do I sort the file the most efficiently?
> >
> > Leif


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---