Corporate Info | News | Solutions | Products | Partners | Services | Events | Download | How To Buy
eLink Information Integrator Doc Home | eLink Information Integrator User Guide | Previous Topic | Next Topic | Contents | Index

Operators

This section describes the operators that can be used in expressions. Operators are defined by type. These types are:

- Existence Operators - Determine if a field exists in a message.

- Integer, String, Float, Date, Time, and DateTime Operators - Evaluate a message field against a static value using the specified operator symbol.

- Field-to-Field Operators - Compare two groups of data (fields) within a message.

Specific operators only apply to a certain data types. For example, there are no operators that compare integer and float data types. Operators are executed against a field name and a value or between two field names (each of the field names must be of the same type, as defined by the Message Type).

The tables that follow describe the valid operator values for the various operator types.

Table E-1 Existence Operators

####

Operator | Description
--- | ---
EXIST | Checks to see if the field is present in the message.
NOT_EXIST | Checks to see if the field is not present in the message.

Table E-2 String Operators

####

Operator | Description
--- | ---
STRING= | Checks to see if the field is equal to the defined literal string.
STRING<> | Checks to see if the field is not equal to the defined literal string.
STRING< | Checks to see if the field value (string) is less than the defined literal string.
STRING> | Checks to see if the field value (string) is greater than the defined literal string.
STRING<= | Checks to see if the field value (string) is less than or equal to the defined literal string.
STRING>= | Checks to see if the field value (string) is greater than or equal to the defined literal string.

Note: String operators do not check for variations in case. "TEST" is the same as "test" or "Test."

Table E-3 Field-to-Field String Operators

####

Operator | Description
--- | ---
F2FSTRING= | Checks to see if the two field values (strings) are equal.
F2FSTRING<> | Checks to see if the two field values (strings) are not equal.
F2FSTRING< | Checks to see if the contents of Field1 (string) are less than the contents of Field2 (string).
F2FSTRING> | Checks to see if the contents of Field1 (string) are greater than the contents of Field2 (string).
F2FSTRING<= | Checks to see if the contents of Field1 (string) are less than or equal to the contents of Field2 (string).
F2FSTRING>= | Checks to see if the contents of Field1 (string) are greater than or equal to the contents of Field2 (string).

Note: Field-to-Field String operators do not check for variations in case. "TEST" is the same as "test" or "Test."

Table E-4 Case Sensitive String Operators

####

Operator | Description
--- | ---
CS STRING= | Checks to see if the field is equal to the defined case-sensitive literal string.
CS STRING<> | Checks to see if the field is not equal to the defined case-sensitive literal string.
CS STRING< | Checks to see if the field value (string) is less than the defined case-sensitive literal string.
CS STRING> | Checks to see if the field value (string) is greater than the defined case-sensitive literal string.
CS STRING<= | Checks to see if the field value (string) is less than or equal to the defined case-sensitive literal string.
CS STRING>= | Checks to see if the field value (string) is greater than or equal to the defined case-sensitive literal string.

Notes: Case-sensitive string operators do check for variations in case. "TEST" is not the same as "test" or "Test."

Case-sensitive operators may not work correctly on case-insensitive databases

Table E-5 Case Sensitive Field-to-Field String Operators

####

Operator | Description
--- | ---
F2FCSSTRING= | Checks to see if the two field values (case-sensitive strings) are equal.
F2FCSSTRING<> | Checks to see if the two field values (case-sensitive strings) are not equal.
F2FCSSTRING< | Checks to see if the case-sensitive contents of Field1 (string) are less than the case-sensitive contents of Field2 (string).
F2FCSSTRING> | Checks to see if the case-sensitive contents of Field1 (string) are greater than the case-sensitive contents of Field2 (string).
F2FCSSTRING<= | Checks to see if the case-sensitive contents of Field1 (string) are less than or equal to the case-sensitive contents of Field2 (string).
F2FCSSTRING>= | Checks to see if the case-sensitive contents of Field1 (string) are greater than or equal to the case-sensitive contents of Field2 (string).

Notes: Case-sensitive Field-to-Field String operators do check for variations in case. "TEST" is not the same as "test" or "Test."

Case-sensitive Field-to-Field String operators may not work correctly on case-insensitive databases.

Table E-6 Integer Operators

####

Operator | Description
--- | ---
INT= | Checks to see if the field is equal to the defined integer value.
INT<> | Checks to see if the field is not equal to the defined integer value.
INT< | Checks to see if the field value (integer) is less than the defined integer value.
INT> | Checks to see if the field value (integer) is greater than the defined integer value.
INT<= | Checks to see if the field value (integer) is less than or equal to the defined integer value.
INT>= | Checks to see if the field value (integer) is greater than or equal to the defined integer value.

Table E-7 Field to Field Integer Operators

####

Operator | Description
--- | ---
F2FINT= | Checks to see if the two field values (integers) are equal.
F2FINT<> | Checks to see if the two field values (integers) are not equal.
F2FINT< | Checks to see if the contents of Field1 (integer) are less than the contents of Field2 (integer).
F2FINT> | Checks to see if the contents of Field1 (integer) are greater than the contents of Field2 (integer).
F2FINT<= | Checks to see if the contents of Field1 (integer) are less than or equal to the contents of Field2 (integer).
F2FINT>= | Checks to see if the contents of Field1 (integer) are greater than or equal to the contents of Field2 (integer).

Table E-8 Float (Decimal) Operators

####

Operator | Description
--- | ---
Float= | Checks to see if the field is equal to the defined float value.
Float<> | Checks to see if the field is not equal to the defined float value.
Float< | Checks to see if the field value (float) is less than the defined float value.
Float> | Checks to see if the field value (float) is greater than the defined float value.
Float<= | Checks to see if the field value (float) is less than or equal to the defined float value.
Float>= | Checks to see if the field value (float) is greater than or equal to the defined float value.

Table E-9 Date and Time Operators

####

Operator | Operator Type | Data Type | Description
--- | --- | --- | ---
DATE= | Date Operator | DATE | Checks to see if the field is equal to the defined date value.
DATE<> | Date Operator | DATE | Checks to see if the field is not equal to the defined date value.
DATE< | Date Operator | DATE | Checks to see if the field value (date) is less than the defined date value.
DATE> | Date Operator | DATE | Checks to see if the field value (date) is greater than the defined date value.
DATE<= | Date Operator | DATE | Checks to see if the field value (date) is less than or equal to the defined date value.
DATE>= | Date Operator | DATE | Checks to see if the field value (date) is greater than or equal to the date integer value.
F2FDATE= | Field to Field Date Operator | DATE | Checks to see if the two field values (dates) are equal.
F2FDATE<> | Field to Field Date Operator | DATE | Checks to see if the two field values (dates) are not equal.
F2FDATE< | Field to Field Date Operator | DATE | Checks to see if the contents of Field1 (date) are less than the contents of Field2 (date).
F2FDATE> | Field to Field Date Operator | DATE | Checks to see if the contents of Field1 (date) are greater than the contents of Field2 (date).
F2FDATE<= | Field to Field Date Operator | DATE | Checks to see if the contents of Field1 (date) are less than or equal to the contents of Field2 (date).
F2FDATE>= | Field to Field Date Operator | DATE | Checks to see if the contents of Field1 (date) are greater than or equal to the contents of Field2 (date).
TIME= | Time Operator | TIME | Checks to see if the field is equal to the defined time value.
TIME<> | Time Operator | TIME | Checks to see if the field is not equal to the defined time value.
TIME< | Time Operator | TIME | Checks to see if the field value (time) is less than the defined time value.
TIME> | Time Operator | TIME | Checks to see if the field value (time) is greater than the defined time value.
TIME<= | Time Operator | TIME | Checks to see if the field value (time) is less than or equal to the defined time value.
TIME>= | Time Operator | TIME | Checks to see if the field value (time) is greater than or equal to the time integer value.
F2FTIME= | Field to Field Time Operator | TIME | Checks to see if the two field values (times) are equal.
F2FTIME<> | Field to Field Time Operator | TIME | Checks to see if the two field values (times) are not equal.
F2FTIME< | Field to Field Time Operator | TIME | Checks to see if the contents of Field1 (time) are less than the contents of Field2 (time).
F2FTIME> | Field to Field Time Operator | TIME | Checks to see if the contents of Field1 (time) are greater than the contents of Field2 (time).
F2FTIME<= | Field to Field Time Operator | TIME | Checks to see if the contents of Field1 (time) are less than or equal to the contents of Field2 (time).
F2FTIME>= | Field to Field Time Operator | TIME | Checks to see if the contents of Field1 (time) are greater than or equal to the contents of Field2 (time).
DATETIME= | DATETIME Operator | DATETIME | Checks to see if the field is equal to the defined DATETIME value.
DATETIME<> | DATETIME Operator | DATETIME | Checks to see if the field is not equal to the defined DATETIME value.
DATETIME< | DATETIME Operator | DATETIME | Checks to see if the field value (DATETIME) is less than the defined DATETIME value.
DATETIME> | DATETIME Operator | DATETIME | Checks to see if the field value (DATETIME) is greater than the defined DATETIME value.
DATETIME<= | DATETIME Operator | DATETIME | Checks to see if the field value (DATETIME) is less than or equal to the defined DATETIME value.
DATETIME>= | DATETIME Operator | DATETIME | Checks to see if the field value (DATETIME) is greater than or equal to the DATETIME integer value.
F2FDATETIME= | Field to Field DATETIME Operator | DATETIME | Checks to see if the two field values (DATETIMEs) are equal.
F2FDATETIME<> | Field to Field DATETIME Operator | DATETIME | Checks to see if the two field values (DATETIMEs) are not equal.
F2FDATETIME< | Field to Field DATETIME Operator | DATETIME | Checks to see if the contents of Field1 (DATETIME) are less than the contents of Field2 (DATETIME).
F2FDATETIME> | Field to Field DATETIME Operator | DATETIME | Checks to see if the contents of Field1 (DATETIME) are greater than the contents of Field2 (DATETIME).
F2FDATETIME<= | Field to Field DATETIME Operator | DATETIME | Checks to see if the contents of Field1 (DATETIME) are less than or equal to the contents of Field2 (DATETIME).
F2FDATETIME>= | Field to Field DATETIME Operator | DATETIME | Checks to see if the contents of Field1 (DATETIME) are greater than or equal to the contents of Field2 (DATETIME).

Copyright © 2000 BEA Systems, Inc. All rights reserved. Required browser: Netscape 4.0 or higher, or Microsoft Internet Explorer 4.0 or higher.