RE: End Request not allowed (how does this work?)

["Murphy, David" <murphy_d@xxxxxxxxxxxxxxxxxxxxxx>]

The behavior you describe appears to occur (in my experience) when the system 
is building an index for the query or sql. The only difference I see between 
your two scenarios is that in the first one you let the query run a bit, but in 
the second one it sounds as if you cancelled it right after starting it. So 
perhaps it didn't have a chance to start building an index (or maybe it used 
the one it had already built?).

-----Original Message-----
From:   owner-midrange-l@midrange.com  On Behalf Of Ravi
Sent:   Tuesday, July 21, 1998 9:46 AM
To:     MIDRANGE-L@midrange.com
Subject:        End Request not allowed (how does this work?)

Hello all,

Can someone explain how "end request works" in the following scenarios:

1)
I was in the JDE menu system which has a command line at the bottom and
got into ISQL by typing STRSQL. I ran a query which took a while to run,
so I got into the System Request menu and took option 2, to end previous
request. I got a message "End Request not allowed" (CPF7121).
The call stack entries were: 

 QCMD      
 J98INITA  
 J98INITV  
 P00MENU   
 J00CMDA   
 QCMDEXC   
 QSQIMAIN  
 QSQISE    
 QWSGET    
 QT3REQIO  
           
          
2)
In trying to ivestigate this further, from the menu system, I got into
the command entry screen by "call qcmd", got into ISQL by typing STRSQL,
ran the same query, got into the system request menu, took option 2
which worked and got out of ISQL. 
Call stack entries were:
 QCMD     
 J98INITA 
 J98INITV 
 P00MENU  
 J00CMDA  
 QCMDEXC  
 QCMD     
 QSQIMAIN 
 QSQISE   
 QWSGET   
 QT3REQIO 
          

How is that "end request" worked in the 2nd scenario and not the 1st? 
Would the menu system somehow control this? I am on V4R2M0 if that makes
a difference. How does one create a "request processing program" as
mentioned in the message description of CPF7121?

Thanks in advance.

Ravi
Systems group, Inc
+---
| 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
+---

+---
| 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
+---