View SARGRW utility logical operator for MASKING sysoutid selection
search cancel

View SARGRW utility logical operator for MASKING sysoutid selection

book

Article ID: 202830

calendar_today

Updated On:

Products

Deliver View

Issue/Introduction

Customer is using the SARGRW utility to select specific sysouts from the 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 : View 14.0

Resolution

We can MASK the sysout ID parameter using the LIKE logical operator rather than the EQ logical operator.

Example 1:

In 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 View documentation.