RE: Starting Line Number for a Splf

David,

It sounds as though you're not going to be able to accomplish your task
using a cpyf with overrides to the print file.  Perhaps a logical next
step would be to create your own command, pass it the filename/library
of the import file, and run that file through a small RPG program which
would write the records out to QPRINT with appropriate overflow
conditioning.  This would duplicate your current functionality.

Alternatively, you could output the CSV file to the IFS and send it as
an attachment.  This way it could be read directly into excel when
received at the other end.

Regards,
Andy Nolen-Parkhouse

> On Behalf Of David Wright
> Subject: RE: Starting Line Number for a Splf
>
> Hi Andy/Doug/All,
>
> The simple need:
> Copy pf to splf with no overflow headers (blank lines)...
>
> How we are trying to do it:
> OVRPRTF to set page length to 1, overflow to 1.  When you do the cpyf,
you
> get the message that the first starting line default of 6 is not valid
> (try it).  Using 255/255 does not generate an error, but you still get
5
> blank lines after every 255 lines...
>
>
> Why we are trying:
> We have a pf that we have used CPYTOIMPF to create a CSV format file.
We
> are using Gumbo's SpoolMail (awesome tool) to email these .CSVs to
remote
> users for use in Excel.  Everything works great, but every time there
is
> an overflow you get blank lines...
>
>
> Hope that clarifies a bit,
> David