BOOLEAN data types
|
|
- Equivalent to Boolean "1" or "True"
|
|
|
- Equivalent to Boolean "0" or "False"
|
|
|
|
Date Time data types |
|
|
NULL data type |
|
|
Numeric
data types
|
- 12678967.543233 with or without quotation marks
|
- Cannot express an exponent or a leading plus sign.
|
|
- 1.7976931348623158 with or without quotation marks
|
- Cannot express an exponent or a leading plus sign.
|
|
- 9223372036854775807 with or without quotation marks
|
- Cannot express an exponent or a leading plus sign.
|
REFERENCE data type |
- FilterExpression '/' RelativeLocationPath
|
- For example, $InputRoot/MQMD/Priority
|
String data types |
|
|
|
- No equivalent
- No equivalent
- Literal
|
-
-
- For example 'a "b"' or "a 'b'"
|
|
|
- Can assign such a variable any valid value, of type Boolean,
number, or string.
|
Simple comparison
operators |
|
|
|
|
|
Complex comparison
operators |
|
|
Logical operators |
|
|
|
|
-
-
- The not function returns true if its argument is false, and false
otherwise.
|
Numeric operators |
|
|
|
- - Unary expression
- +
- -
- *
- div
|
|
String operator |
|
|
Date time functions |
|
|
Numeric functions |
|
|
|
- floor (number)
- ceiling (number)
- No equivalent
|
|
String manipulation
functions
|
- substring(string, number, number)
|
|
|
- translate(string, string, string)
|
|