asked on Suppress print to spool file when using RUNSQLSTM in CL Program
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
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
* iSeriesSQLIBM System i
Last Comment
Gary Patterson, CISSP
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.