Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

How can multiple clipper queries be run in one batch job using the ClipperSearch.BJ process?

How can multiple clipper queries be run in one batch job using the ClipperSearch.BJ process?

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

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-12-11 14:00
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.