Operators


	Corporate Info \| News \| Solutions \| Products \| Partners \| Services \| Events \| Download \| How To Buy
	http://www.oracle.com/technology/documentation/index.html \| Search \| PDF Files \| Contact \| Glossary

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.

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.

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).

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.

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).

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.

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).

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.

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.

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).