Re: Command for Limiting Query to run in Batch only

[MacWheel99@xxxxxxx]

>  From:    bm@datrek.com (Betty McDowell)
>  
>  We use the CL approach for queries we want users to be able to run in 
> batch.
>  On the runqry statement you can put RCDSLT(*yes) which allows the user to
>  change selection criteria, such as date for that particular run.

We do CL on BPCS Menus for an enormous volume of our Queries ... but ideally 
we want the 
RCDSLT(*YES) to kick in & capture whatever the user wants, then we want
SBMJOB to kick in & execute the whole thing on batch JOBQ ... as yet I do not 
know if this is doable, or how.
I got instructions using embedded question marks from one of the 400 on-line 
forums & tried it out & kept running into error messages that I cannot 
combine question marks with RUNQRY ... ie. if doable I still not getting how 
do.

I have the unenviable position of several users who WANT to run Query with 
RCDSLT(*YES) onto JOBQ batch because they now know that interactive query 
over large files has a serious overall performance problem, but I have not 
yet figured out how to deliver that capability in CL.  In fact, if I figure 
out how, I can change a bunch of CL to do that even for users who did not ask 
for it, and so improve performance for everyone.

Al Macintyre  ©¿©
http://www.cen-elec.com MIS Manager Programmer & Computer Janitor 405 CD 
mixed mode AS/400 & a bit ignorant in some areas

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---