Re: Command for Limiting Query to run in Batch only

If you limit QUERY run to BATCH, what happen during query definition and the
user press F5.

----- Original Message -----
From: "Betty McDowell" <bm@datrek.com>
To: <BPCS-L@midrange.com>
Sent: Wednesday, March 08, 2000 12:10 PM
Subject: Re: Command for Limiting Query to run in Batch only


> 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.
>
> -----Original Message-----
> From: MacWheel99@aol.com <MacWheel99@aol.com>
> To: BPCS-L@midrange.com <BPCS-L@midrange.com>
> Date: Wednesday, March 08, 2000 11:05 AM
> Subject: Re: Command for Limiting Query to run in Batch only
>
>
> >> From: RickCarter@holley.com
> >>
> >>  In the last week or so, someone responded to a Query issue with BPCS
and
> >>  one suggestion was setting a query value where the query would only
run
> in
> >>  Batch mode vs Interactive.
> >>  What is that command
> >
> >If you go into WRKQRY and change the Query specifications, then from
within
> >WRKQRY at point of Save yes/no you can save no & JOBQ batch yes, or from
> the
> >WRKQRY menu you can select run in JOBQ batch as opposed to run on-line.
> >
> >But we"re not enthusiastic about the notion of giving users that
capability
> >of changing queries when some users are less skilled at getting this
right
> >than others with communal queries that used to work right & at any moment
> >without us knowing when, some of them get messed up.
> >
> >If you put RUNQRY & some particular selection of QRY into a CL ... you
can
> >then put that CL on SBMJOB like any other JOBQ batch & the CL can OVRPRTF
> >with the usual clarifications ... we use UsrDta heavily to identify which
> is
> >which, however this approach does not give user the option of selecting
> date
> >range & other criteria that we like to have in a query/400.
> >
> >Open Query Path might be a possible alternative, but we are getting away
> from
> >Query to programming.
> >
> >This might not be what you were looking for.
> >
> >Al Macintyre  ©¿©
> >http://www.cen-elec.com MIS Manager Programmer & Computer Janitor
> >http://www.whma.org = our nitch industry has a large committee searching
> for
> >ErPdMes products right for WHM without work-arounds, which for many
members
> >resemble a snipe hunt - if you are in this software business & want to
fix
> >your product so it will not be mistaken for what your competition has
been
> >doing, then you might want to join our great game.
> >
> >Y2K is not the end of my universe, but a re-boot of that old Chinese
curse.
> >The road to success is always under construction.
> >Stiff in opinions, always in the wrong.
> >When you want it cheap - you get what you paid for.
> >When in doubt, read the manual, assuming you can find the right one.
> >+---
> >| 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
> +---

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