Sybase 12.5.1, User Manual

Page: 69 / 210

CHAPTER 4 Command Reference
User’s Guide
55
•
neq
– passes values that are not equal to any value in a list of
values. That is, a value passes the filter if it is not equal to the first
filter value, not equal to the second filter value, and not equal to any
other value in the list. Specify the list of values in the value_spec
parameter.
•
range
– passes values that fall inside a range of values. Specify the
ranges in the value_spec parameter.
•
top
– passes a specified number of values that are the highest values
received for the data item during a sample interval. For example, a
top 10 filter passes the 10 rows of a sample that have the highest
values for the data item.
value_spec
specifies values for the filter tests. The syntax depends on the value of
filter_type:
If filter_type is value_spec syntax is
eq or neq value1[, value2]...
See “Using wildcards” on page 56 for information about
using a wildcard character (%) when valuen is a character
string. See “Specifying filters on object name and
procedure name” on page 56 for information on specifying
a value for the Object Name and Procedure Name data
items.
range
To specify values greater than or equal to a low bound:
low
,value
To specify values less than or equal to a high bound:
high
,value
To specify values greater than or equal to a low bound and
less than or equal to a high bound:
low
,value1,
high
,value2
See “Specifying filters on object name and procedure
name” on page 56 for information on specifying a value for
the Object Name and Procedure Name data items. If you are
specifying both an upper and lower bound for either of these
data items, each bound must have the same number of
subcomponents.
top value
where value is the number of items to be passed. It must be
greater than zero.