Re: help!! -- how to create batch queries in bpcs? -- BPCS-L

That reminds me.
You may find this useful.
We have a CL in which the what query field of RUNQRY is entered at run time
from the menu - we did not even have to create a prompt screen - by using
question marks you can specify the query to run at this time.  You have to
have it default to something & we use our query over all the *QRYDFN in alpha
description of their textual descriptions as a quick reference, for people
who not have command line access or we not want into WRKQRY, of all the
queries we happen to have developed.  You need to be looking at the CL manual
to see how to work the question marks.  And we give them record selection
*YES.

We have some standards for query creation.
Of course not everyone follows the standards.

The most important standard.

Every query needs to have it print SOMEWHERE, such as in the header footer or
total time, what is the NAME of the query, so that if someone sees it, likes
it, wants a copy on other criteria, no one has to search around to find the
thing.

Another standard is to give the query a text description that gives a clue as
to what the heck it is supposed to do, so that if someone else is trying to
figure out the same kind of thing we do not have everyone spinning the same
wheels.

In the last 2 positions of the text description that shows up on WRKQRY
screen we put the initials of the person in charge of this query & we do not
mess with other people query definitions.

You might look at the MIDRANGE-L archives.
There is a thread today on query/400 performance optimization.

There are some standard fields you can populate on a query ... there's an
example in the News/400 query forum (query + SQL + DB2 combination forum) in
how to get at the TEXT of user profile that says who the user is & put that
on the footer line of the query so you have a standard place with whose
report this is ... important consideration if you have a high speed printer
shared by everyone in a big office ... who printed this ... mine mine.

> I have used a generic CL program in many different BPCS environments to do
> what I think you are asking. That way you don't have to setup a new CLP
every
> time you want to put a new query on a BPCS menu you just use the the
generic
> CL program and pass it up to 10 query names that you want to run in the
order
> they are to run. It does have some limitations. Contact me offline if you
> want more information.  Kevin W.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
BPCS 405 CD Manager / Programmer @ Global Wire Technologies Incorporated
http://www.globalwiretechnologies.com = new name same quality wire
engineering company: fax # 812-424-6838