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


  1.  Home
  2. RPG400-L
  3. April 2002

Re: Outputting SQL results to spooled-file

On Thursday 25 April 2002 1:50 pm, Tucker Gerry wrote:
> In Interactive SQL you change session attributes to output the results
> from a select statement to a spooled file.  Is there anyway
> programatically to do this so if I run RUNSQLSTM or in an RPG IV
> program to get the same effect?
>
>
> Regards,
>
> Gerry Tucker

Hi Gerry

Have a look at STRQMQRY which can output to * (screen), *PRINT or
*OUTFILE. If you want a handy front end, grab EXCSQL from my site -
http://www.dbg400.net/excsql.html

It uses a *CMD front end but you could always prototype the CL CPP for
more easy use in RPG (desperately trying to keep on topic ;-)

Regards, Martin
--
martin@dbg400.net  jamaro@firstlinux.net  http://www.dbg400.net        /"\
DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open        \ /
Source free test environment tools and others (file/spool/misc)         X
[this space for hire]  ASCII Ribbon Campaign against HTML mail & news  / \

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.