Re: How to sort a flat text file on the 400.

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

You can use CPYFRMIMPF on the 400 to bring CSV files into physical files. 
The PF just needs the fields defined to match the data. Then you're home free.

HTH

Vern

At 04:06 PM 10/30/2003 -0600, you wrote:
> Any suggestions would be appreciated.
>
> I have a rexx script that parses some data.. And generates some output.
> This run in batch generates a qprint file.
>
> I've been doing a CPYSPLF to copy the file to a test library, and then
> download it to a unix system, where I can sort the darn thing, and
> continue with a rexx script on unix.
>
> I'd like to keep the whole thing on the 400, so I can schedule it to run
> regularly.
>
> I guess I'd like to get the data into a database file where I can then
> SELECT with an ORDER BY clause.
>
> Any suggestions on getting the following looking data into a database?
> "R12345","10/30/2003","10:20:15", etc.. (comma separated values format).
> "R12346","10/30/2003",".....
>
> Thanks..
>
>
>
> This communication is confidential and may be legally privileged.  If you 
> are not the intended recipient, (i) please do not read or disclose to 
> others, (ii) please notify the sender by reply mail, and (iii) please 
> delete this communication from your system.  Failure to follow this 
> process may be unlawful.  Thank you for your cooperation.
> _______________________________________________
> 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.