TCL Retrieve Sentence Operators

Use the following operators to create conditional expressions on the Advanced Report Writer/Mass Load Selection screen.

Use this Operator...

To select a record if the attribute value...

=

EQ

EQUAL

is equal to the reference value.

#

NE

NOT

NO

<>

><

is not equal to the reference value.

>GT

AFTER

GREATER

is greater than the reference value.

<

LT

BEFORE

LESS

is less than the reference value.

>=

GE

is greater than or equal to the reference value.

<=

LE

is less than or equal to the reference value.

 

Use the following operators to determine a sort sequence for the data:

Use this Operator

To...

BY

sort by the reference value in ascending order.

BY-DSND

sort by the reference value in descending order.

See Also:

Using Advanced Record Selection

Report Writer/Mass Load Overview