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



I am using RUNSQLSTM to create a view in QTEMP (repeatedly).  I have
created a loop that removes, re-creates, reads, then deletes the view,
each time over a file in a different library.  The problem is that,
even if I specify OUTPUT(*NONE) (which is the default), I still get a
printout.  The command I am using is:

RUNSQLSTM SRCFILE(QTEMP/TEMPSQL)
          SRCMBR(TEMPSQL)       
          NAMING(*SQL)          
          ERRLVL(40)            
          OUTPUT(*NONE)         


If there are no errors, no matter what, the statement above generates
a printout.  This is clearly a bug, so I am searching for a way around
it.  Is there an easy way to remove the spooled files from the job
after each run?  I know I can override the print file to a certain
USRDTA, and then DLTSPLF for that group of spooled files, but it just
seems ridiculous!  I want no output!  HELP!


-- 
"Enter any 11-digit prime number to continue..."

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.