× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.