Re: SQL Fetch causes jjob message queue overflow

You do have the option of changing the job message system value to wrap the
messages as there are system values to handle this problem. Although
creating a new job once in a while is not a bad idea either.

How long does your job run before this problem occurs?

Ken Slaugh  (707) 795-1512 x118
Chouinard & Myhre, Inc.
AS/400 Professional Administrator/MSE
Client Access Specialist
http://www.cm-inc.com/


                                                                                
            
                    "William Washington                                         
            
                    III"                       To:     
<MIDRANGE-L@midrange.com>            
                    <w.washington3@star        cc:                              
            
                    band.net>                  Subject:     SQL Fetch causes 
jjob message   
                    Sent by:                   queue overflow                   
            
                    owner-midrange-l@mi                                         
            
                    drange.com                                                  
            
                                                                                
            
                                                                                
            
                    04/26/01 05:14 PM                                           
            
                    Please respond to                                           
            
                    MIDRANGE-L                                                  
            
                                                                                
            
                                                                                
            




Hi All,

I have an interactive program that uses SQL FETCH statement to read
records.  Even though the SQLCOD is zero (i.e., ends normally,) it puts a
message on the job message queue.  The message is SQL7963 - Fetch 1 record
....

How do I prevent the informational/completion message from generating in my
job message queue (and job log)?  It kills my session once a certain number
of messages has been sent.

Thanks in advance...

William

===============================
William Washington III
Njia Systems Incorporated
w.washington3@njiasystems.com
312-719-0519
===============================



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---