Re: How to make one file into many and download into CSV TXT files

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Thomas

Any idea of a quick solution probably involves a vendor product.

This could be done with SQL - you can build the SELECT for the distinct 
values from your sort, then walk through them, using another SELECT with 
parameter marker that takes each distinct value. For each distinct 
value, create the CSV.

One trick for the CSV - use SQL to build each CSV row in a PF, then use 
CPYTOIMPF to create the IFS file.

Not too ugly, eh?

HTH
Vern

On 1/5/2015 2:56 PM, Thomas Burrows wrote:
> Hi:
>
> Is there a quick way to take one file that is sorted and break into many
> files according to the sort value? Then quickly download to a CSV TXT file.
> Know how to do this in general, but each day there will be an unknown
> number of individual sort fields. Usually under fifty but could be maybe 75
> to 100.
>
> Hoping for a quick solution than the rather hard solution I am thinking of.
>
> Thomas