|
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 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.