Re: WDSC as a complete work environment

Adam,

If your result set is in a physical file on the iSeries, there are a 
number of tools available to convert this to an XLS file, which you can 
then email to the user.

<tool creator reply>
Have a look at my CPYPF2XLS tool, hosted by Leif Guldbrand over at 
http://www.think400.dk/downloads.htm )
</reply>

HTH,

Peter Colpaert
Application Developer
PLI - IT - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----



AGlauser@xxxxxxxxxxxx 
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
26/10/2006 17:33
Please respond to
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>


To
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>
cc

Subject
Re: [WDSCI-L] WDSC as a complete work environment






Douglas Belcher wrote on 26/10/2006 11:28:11 AM:

Are you talking about printing or emailing results from Quantum DB?

Not specifically.

 If
you are, then what I normally do on one-offs is to get the SQL right,
then right mouse click on the result set and export it to Excel and
email that.  It generally works pretty good for that but I wouldn't want
to use it for any kind of production use.  SQL is just not a printing
product.

Thanks for the tip Doug.  I've already done this a couple of times, and I 
agree that it is not a solution for anything other than 'one-offs', mainly 

due to the manual work involved.

I guess what I really need to do is write a program which reads an 
arbitrary SQL result set and makes a spool file from it.  Sounds like one 
of those 'when I get spare time' things that never happens ....

Thanks again for the tip,
Adam