![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
You cannot substitute the keyword NOT for the not sign (¬) symbol. Use only in selection criteria statements, not in condition statements.Note the following points about semantic data types and syntax in expressions containing these operators:
• The relational operators for equality and inequality (=, ¬=) can be used with any two operands of the same semantic data type. They can also be used for two operands of different semantic data types if one of the operands is typeless or if the types are identifier and string, or identifier and count.
• The relational operators for ordering (<, <=, >, >=) cannot be used with an operand of type logical. Otherwise, they can be used with two operands with the same semantic data type or if one operand is typeless.
• The relational operator for pattern matching (LIKE) can be used with any semantic data types and always returns a logical value.
• Trailing blanks are significant for variable-length strings, but not for fixed-length strings. For example, comparing two fixed-length strings with lengths 12 and 16 gives the same result as if the shorter string were extended to length 16 and padded with four blanks on the right.
• If syntax differs, operands are converted to a common syntax. Refer to Chapter 12, Arithmetic Processing for a table of syntax conversions.
• The LIKE relational operator is not case sensitive if you are matching syntax C data. In all other cases, the other relational operators distinguish between upper and lowercase.The relational operators for equality and inequality are = and ¬=. The following chart shows the semantic types on which you can use these operators. In each case, the result of the relational operation is a logical value. Y indicates a valid operation.
The relational operators for ordering are <, >, <=, and >=. The following chart shows the semantic data types on which you can use these operators. In each case the result of the relational operation is a logical value. Y indicates a valid operation.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |