MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2004

RE: RUNSQLSTM



fixed

A real PITB.  Here's how I handle it:

/* Override the QSYSPRT file so that the SQL View "compile" listing */ 
/*  will not print. (Couldn't figure out how not to generate it.)   */ 
    OvrPrtf    QSYSPRT  Hold( *Yes ) UsrDta( DeleteMe )                
                                                                       
/* Build the qTemp SQL View used to print report */                    
    RunSQLstm  SrcFile( BSGLIB/QDDSSRC ) SrcMbr( RSS033SQLV ) +        
                 Commit( *None ) Naming( *Sys )                        
                                                                       
    DltSplf    RSS033SQLV  SplNbr(*Last) +                             
                 Select(*Current *All *All DeleteMe)                   

hth,
db

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx / Tim Ellifritz
> Sent: Tuesday, October 12, 2004 8:53 AM
> 
> When using the RUNSQLSTM what parameter controls the spooled output that
> shows the source and parameters?
> 
> Can it be turned off so it doesn't generate this?
> 
> Thanks,
> Tim





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact