Re: RunSQLStm Problem

["Dave Boettcher" <DBoettch@xxxxxxxxxxxxxxxx>]

Guessing that your looping is in another program, you could use
something like this.

DLTSPLF    FILE(QPQUPRFIL) SPLNBR(*LAST)

hth, 

Dave Boettcher

>>> carolla@xxxxxxxxx 03/11/2005 11:39:25 AM >>>
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..."
-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l 
or email: RPG400-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.