Check this thread out for some options:
Celebrating 11-Years of SQL Performance Excellence on IBM i5/OS and OS/400
I've just put a RUNSQLSTM in a program. Its the first time I've used this
command for a program intended for production. I've been told to get rid of
the spoolfile generated by this command, but I can't see how to do it. In
the CL program I use MONMSG SQL0000 directly after the RUNSQLSTM. It would
be good if I could keep the spooled output if any errors were generated.
Any ideas ? Thanks.
This mailing list archive is Copyright 1997-2019 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