gmollineau

<div>
I usually prefer to use OPTION(*ERRLIST) to get a listing only when an error occurs. &nbsp;OPTION(*NOLIST) completely turns off listings, which can make troubleshooting difficult if something goes wrong.
</div>


I usually prefer to use OPTION(*ERRLIST) to get a listing only when an error occurs.  OPTION(*NOLIST) completely turns off listings, which can make troubleshooting difficult if something goes wrong.

<div>
<div class="content wysiwyg-content fr-view">
Good Day<br><br>I have an iSeries CL program in which I use the RUNSQLSTM command.<br><br>I have used *NONE for the Output parameter but every time the CL Program runs the RUNSQLSTM is outputting an entry in the Spool file (see attached).<br><br>Can someone advise how do I suppress this output to spool file.<br><br>Regards<br><br>Gerald<br>&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2021/05_w20/1560549/RUNSQLSTM_Spool_Output.pdf" rel="ugc">RUNSQLSTM_Spool_Output.pdf</a>
</div>
</div>


RUNSQLSTM_Spool_Output.pdf


Good Day
I have an iSeries CL program in which I use the RUNSQLSTM command.
I have used *NONE for the Output parameter but every time the CL Program runs the RUNSQLSTM is outputting an entry in the Spool file (see attached).
Can someone advise how do I suppress this output to spool file.
Regards
Gerald
 
RUNSQLSTM_Spool_Output.pdf

Suppress print to spool file when using RUNSQLSTM in CL Program

iSeriesSQL

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.