Skip to Content

Using logical operators in SELECT filters

A logical operator indicates how the value of the record field must be compared to the filter value for the comparison to result in a true condition.

For SELECT expressions other than the SELECT=ETIME expression, to select the record if the value in the record matches the specified value, use the equal sign (=) logical operator. To select the record if the value in the record does not match the specified value, use the NOT= (a literal NOT, followed by an equal sign) logical operator.

For the SELECT=ETIME expression, use the greater-than sign (>) or less than (<) sign as the logical operator.

A logical operator indicates whether the value of the record field must be equal to or not equal to the filter value for the comparison to result in a true condition.

Related topic

Specifying-SELECT-filters

The following example shows the use of complex SELECT filters. They search for LUOWs in which the transaction name LOCLTRAN was input from OTMA except those from TPIPEs that begin with the value FRED.

ANALYZE                                        
   SLDS=(TME.RIP.LUI.IMSV9.SLDSPL15.P1,R141)    
   SLDS=(TME.RIP.LUI.IMSV9.SLDSPL15.P2,R141)    
INTERVAL START=FIRST STOP=LAST
FILTER
   CONT=DATA                                      
   SELECT=(01DEST=LOCLTRAN AND TPIPE NOT=FRED*)   
END


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Log Analyzer for IMS 1.7