RE: Command for Limiting Query to run in Batch only

I couldn't find a way to do this with query so we've been switching to Query
Manager.  
I use a CL to allows the user to enter the parameters via a DSPF and with a
CL load these parameters to a LDA.  I then have a second CL that retrieves
the LDA and passes them as variables to the Query Manager.
If you have the May 1997 issue of News/400 there is a good article that
starts on page 83 about how to pass parameters to queries.
I don't know if this is what you want but it is one method that you could
look at.

Jerri Martin 

> -----Original Message-----
> From: Bill Robins [SMTP:brobins3d@yahoo.com]
> Sent: Thursday, March 09, 2000 10:45 AM
> To:   BPCS-L@midrange.com
> Subject:      Re: Command for Limiting Query to run in Batch only
> 
> > 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.
> 
> One way of doing it is to load your selection criteria into a 1 record
> work
> file.  Since it is only 1 record, this would result in a Join *all.  Use
> the
> information in this file to do your dynamic selection criteria.
> 
> Bill
> 
> 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
> 
> +---
> | 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
> +---
+---
| 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
+---