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

["Bill" <brobins3d@xxxxxxxxx>]

Johnson,

> 1. I have 10 seperate queries, and I want to create a batch query to run all
the
> queries in a specified sequence. Because I have to input some parameters (some
> dates), I think I have to create a parameter input dialogue before I run the
> batch query. How can I do that?

There are a couple of ways to handle input parameters.  If there are dates
involved I could explain how to use the built in functions in Query to handle
dynamic date selection.

If there are other criteria, then the best solution I have heard of is to prompt
for the selection criteria in the master CL program, load this data in a file,
join your queried files to this master file.

As someone else mentioned, the command to run a Query from a command line or a
CL program is RunQry.

Bill


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com