Problem :

Clipper queries can be run in batch by using the ClipperSearch.BJ, which is designed to run one query at a time. How can multiple queries be run in batch using this process?

Resolution :

To run clipper queries in batch, the ClipperSearch.Bj should be run, with an associated ClipperMetrics.bj and/or ClipperDetail.bj.

Example separate .bat files that run the standard "Dead Statements" and "Possible Sign Loss" clipper queries are included in the attached zip file.  (Clipper_DeadStatements.bat and Clipper_PossSignLoss.bat)

The easiest way to run multiple queries is to have separate .Bat files that can be run as Windows tasks, or to run the .bat files from a command line manually.

To speed up this process, an "outer" .bat file can be used which runs any number of the separate clipper queries.bat files. 

This .bat file can be run manually from a command line, as a windows task or even as part of the Batch Refresh Process.

An example of this file to run both of the standard "Dead Statements" and "Possible Sign Loss" clipper queries in one .bat job is included in the attached zip file. (MultipleClipperSearches.bat)

ClipperQueries.zip

Incident# 2649337