|
Thanks Peter, I'll have a look. Brian. -----Original Message----- From: Peter.Colpaert@xxxxxxxxxx [mailto:Peter.Colpaert@xxxxxxxxxx] Sent: Thursday, September 15, 2005 8:22 AM To: RPG programming on the AS400 / iSeries Subject: Re: Filling a Subfile with an SQL statement / Writing a CSV Brian, regarding your second question, you could always use the Jakarta POI classes to output a "real" excel sheet, and have the user pick it up from the IFS, or mail it to him/her. Alternatively, you could output to a workfile, and have the user import it into excel using the iSeries Access data transfer add-in. HTH, Peter Colpaert Application Developer Massive - Kontich, Belgium ----- Yoda of Borg are we. Futile is resistance, assimilated will you be. ----- "Brian Piotrowski" <bpiotrowski@xxxxxxxxxxxxxxx> Sent by: rpg400-l-bounces@xxxxxxxxxxxx 15/09/2005 14:10 Please respond to RPG programming on the AS400 / iSeries To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx> cc: Subject: Filling a Subfile with an SQL statement / Writing a CSV Hi All, When I use an SQL statement to obtain information to a database, do I need to create a cursor in order to write the data to a subfile? Is there a way to do something like a DoW not %eof(SQL returned records)? The other question I have regards writing a CSV file. Right now, we have a null device where all of our "scratch" data is written (PRT01). One of the users on our system needs to have the results of a query written to a file that will be exported to an Excel spreadsheet. I was planning on simply writing the file to our scratch drive and have them grab the print file using Navigator. Does anyone know if there is a better way to do this? Thanks! Brian. -=-=-=-=-=-=-=-=-=-=-=-=-=- Brian Piotrowski Specialist - I.T. Simcoe Parts Service, Inc. Ph: 705-435-7814 x343 Fx: 705-435-6746 bpiotrowski@xxxxxxxxxxxxxxx -=-=-=-=-=-=-=-=-=-=-=-=-=-
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.