search cancel

CA View SARGRW utility logical operator for MASKING sysoutid selection

book

Article ID: 202830

calendar_today

Updated On:

Products

Deliver View

Issue/Introduction

We are using the SARGRW utility to select specific sysouts from the CA View database using the logical operator of "EQ"

Example:  /SELECT ID EQ 'sysoutid'

Is there a MASKING function available with the SARGRW utility that would allow us to use, for example, /SELECT ID EQ '*xyz'  so that only sysoutids ending with the characters of 'XYZ' would be selected? 

Environment

Release : 12.2, 14.0

Component : CA View

SARGRW

Resolution

The answer is yes, you can MASK the sysout ID parameter using the LIKE logical operator rather than the EQ logical operator.

 

Example 1 -

In your SARGRW control statements...

Instead of coding:           /SELECT ID EQ 'sysoutid'

Code the statement as:  /SELECT ID LIKE '*XYZ'

So that only sysoutids ending with the characters of 'XYZ' would be selected 

 

Example 2 - 

Using the statement:      /SELECT ID LIKE 'ABC*'

Would select all sysouts that started with the characters "ABC"                                          

Additional Information

For more information on using the SARGRW utility, please refer to the topic "General Report Writer" in the CA View documentation.